Jon Galloway
-- t-sql scriptlet to drop all constraints on a tableDECLARE @database nvarchar(50)
DECLARE @table nvarchar(50)
set @database = 'GenApp'
set @table = 'ParamDescriptor'
DECLARE @sql nvarchar(255)
WHILE EXISTS(select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where constraint_catalog = @database and table_name = @table)
BEGINselect @sql = 'ALTER TABLE ' + @table + ' DROP CONSTRAINT ' + CONSTRAINT_NAME
from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where constraint_catalog = @database and
table_name = @tableexec sp_executesql @sql
END
Posts
No comments:
Post a Comment
- the first minus - Comments have to be moderated because of the spammers
- the second minus - I am very lazy at moderating comments ... hardly find time ...
- the third minus - Short links are no good for security ...
- The REAL PLUS : Any critic and positive feedback is better than none, so your comments will be published sooner or later !!!!