Home Forums SQL Server 2008 SQL Server Newbies Renameing a column in all tables in a sql 2008 database RE: Renameing a column in all tables in a sql 2008 database
spaghettidba
SSC Guru
Points: 105732
More actions
October 26, 2010 at 6:47 am
#1242204
You can use sp_rename:
EXEC sp_rename 'schema.table.name', 'newname', 'COLUMN'
As for adding new columns, you can use ALTER TABLE:
ALTER TABLE tablename ADD [column definition]
-- Gianluca Sartori