rename table & column name in PL-SQL & T-SQL

In T-SQL :

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

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

In PL-SQL :

The script for renaming any object (table, sp etc) :

Alter table Stu_Table rename to Stu_Table_10)

Thursday, November 19, 2009