SQL Query [resolved]

[Ruku]

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?

[Asgorath]

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

[Ruku]

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 .