Printable View
After creating an SQL table, is there a way to rename a column from a simple query?
(Alter, or update...?)
I'm using MS SQL Server 2000...
I am told this cannot be done unless going through all the files and renaming the appropriate fields with a program...
True? :wave:
Of course its possible:
This example renames the contact title column in the customers table to title.
EXEC sp_rename 'customers.[contact title]', 'title', 'COLUMN'
Jorge
EXEC sp_rename 'customers.[contact title]', 'title', 'COLUMN'
exacly... so you really need an executable program from the server agent, not a simple function query... looks like there is no other way :).