Posted by Martijn Tonies on 10/01/38 11:19

> This should do what you need on your current database
>
> declare @tablename varchar(30)
> declare c1 cursor for select name from sysobjects where type = 'U'
> open c1
> fetch next from c1 into @tablename
> while ( @@fetch_status <> -1 )
> begin
> exec ( 'alter table ' + @tablename + ' check constraint all ')
> fetch next from c1 into @tablename
> end
> deallocate c1
> go

Easy iteration can be done via
master.sp_MSforeachtable :-)


--
With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com

• Next in forum: exclude query
• Prev in forum: Re: Have a better UPDATE statement than what I wrote?
• Thread view: Re: How to Disable ALL Constraint In ALL Tables

[Reply to this message]