Hi everyone,

Does anyone know the SQL statement to rename a table in SQL Server. I want to write a stored procedure that will rename a bunch of tables.

I tried statements like:

ALTER TABLE Tab TO TABLE
RENAME TABLE Tab TO Table (This works on Oracle).

But I have had no luck so far. If someone can offer any help, I would be grateful.

Thanks,

Pankaj

Just use the stored procedure that already exists. sp_rename 'old_table_name', 'new_table_name'

You can use sp_rename to do that.

_________________________
-Vijay G
Strive for Perfection

Hi,

Yes, you can use sp_rename for renaming a table or column in SQL Server. The only difference is that if you want to rename a column witbin a table you need to provide proper namespace.

for e.g.

for renaming a table
EXEC sp_rename 'Old_TableName', 'New_TableName'

for renaming a column
EXEC sp_rename 'TableName.[Old_ColumnName]', 'TableName.[New_ColumnName]', 'COLUMN'

Hope this helps,

Lalit,
Life Means More...;)

Hi everyone,

I am agree with Lalit that sp_rename is helpful in this regard. But for Column rename use the following format :

EXEC sp_rename 'TableName.[Old_ColumnName]', 'New_ColumnName', 'COLUMN'

It's my first time coming to this forum,
to begin with,I'd give a self-introduction and my wish
I come from China,a student on the major of e-commerce
I have been studying asp.net 2.0 and English altogether,
I am happy to communicate with all of you from different areas and
certainly willing to make friends with you.

learning asp.net 2.0 needs help and communications!