Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: delete all constraints for a table

    Try this one, there was an error in above code

    declare @cmd nvarchar(500)

    declare cmds cursor for

    SELECT 'ALTER TABLE ' + IST.table_schema + '.' + OBJECT_NAME(SO.parent_obj) + '...

    June 29, 2007 at 7:36 am

    #716169

  • RE: delete all constraints for a table

    Here is the ultimate solution

    declare @cmd nvarchar(500)

    declare cmds cursor for

    SELECT 'ALTER TABLE ' + IST.table_schema + '.' + OBJECT_NAME(SO.parent_obj)...

    June 29, 2007 at 5:21 am

    #716122

Viewing 2 posts - 1 through 2 (of 2 total)