Using below query all table's having Createdby and Updatedby column should be altered. You don't need to fire query for each table.
SELECT
'ALTER TABLE ' + TABLE_NAME
+ ' ALTER COLUMN Createdby varchar(50) go ' AS Createdby, 'ALTER TABLE ' + TABLE_NAME
+ ' ALTER COLUMN Updatedby varchar(50) go ' AS Updatedby + ';'
FROM INFORMATION_SCHEMA.TABLES
Wednesday, April 2, 2014
How to update DB Column
Wednesday, April 02, 2014
No comments
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment