Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Script alter table all tables in database
Message
From
10/09/2006 22:38:47
Sergey Berezniker
New York, United States
 
 
To
10/09/2006 21:37:16
Charles Hankey
Consultant
Cleveland, Ohio, United States
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Script alter table all tables in database
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01152672
Message ID:
01152694
Views:
19
Yes.

>Thanks Sergey! Does that mean the sp will use the tablename wherever it finds the ?
>
>
>>You can use undocumented sp_MSforeachtable
>>EXEC sp_MSforeachtable @command1="ALTER TABLE ? ..."
>>
>>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform