Answers

HI. How to rename a table name or column name in sql?

Deepali Patil

12y

1.5k

I have used the following query :

alter table tablename rename to newtablename;

but its giving error at 'rename'

there is no keyword as rename.

Answers (2)

hi,

if want to rename a table

exec sp_rename 'oldtable','newtable'

The script for renaming any column :
sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN'

The script for renaming any object (table) : sp_RENAME '[OldTableName]' , '[NewTableName]'

Next Recommended Forum

Printing Statistics

Sub-queries in SQL