Posted by JLavalley on 10/09/61 11:34

Can someone explain to me why the following doesn't work?

declare @oname sysname
select @oname=name from sysobjects where name like
"df__mytable__mycol%"

alter table mytable drop constraint @oname

• Next in forum: Re: dynamically trasnpose rows into columns
• Prev in forum: Re: Indexing a View
• Thread view: Stored Procedure to change default

[Reply to this message]