DaniWeb IT Discussion Community - View Single Post - SQL command to ALTER!! PLease Help

Re: SQL command to ALTER!! PLease Help

Sep 26th, 2008

i would create a stored procedure with a cursor

use this to get the table names

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
SELECT name
FROM dbo.sysobjects
WHERE xtype = 'U'
SELECT name
FROM dbo.sysobjects
WHERE xtype = 'U'

and this dynamic sql to set key

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
exec('alter table ' + @tablename + ' ADD PRIMARY KEY(osd)');
exec('alter table ' + @tablename + ' ADD PRIMARY KEY(osd)');

Custom Application & Software Development
www.houseshark.net