Rename column MS SQL Server

It is often necessary to rename a existing column in the database. Typically “ALTER” is used for such tasks but this time it won’t work.

EXEC sp_rename 'ExampleTable.[ExampleColumnToRename]','NewColumnName', 'COLUMN'

Comments

There were no comments found for this weblog.

Du mußt Dich einloggen um diesen Weblog kommentieren zu können!