| Author: D.Jeya kumar(JK) 20 Aug 2008 | Member Level: Diamond | Rating:  Points: 3 |
Hi,
To rename a Table in Sql server where sp_rename is a store procedure
exec sp_rename 'Old_TableName', 'New_TableName'
In oracle
Rename Table Old_TableName to New_TableName
Regards
JK
|
| Author: Danasegarane.A 20 Aug 2008 | Member Level: Diamond | Rating: Points: 4 |
You have to use the sp_Rename stored procedure
sp_rename
Changes the name of a user-created object (for example, table, column, or user-defined data type) in the current database.
From MSDN :
A. Rename a table
This example renames the customers table to custs.
EXEC sp_rename 'customers', 'custs'
Thanks and Regards,
Danasegarane Arunachalam
|
| Author: UltimateRengan 20 Aug 2008 | Member Level: Diamond | Rating: Points: 1 |
hi,
sp_rename oldtablename,newtablename
Ex:-
sp_rename gr,xx
i hope this may help u
Advance Happy Diwali
SAP B1
|
| Author: Anil Kumar Pandey 20 Aug 2008 | Member Level: Diamond | Rating: Points: 2 |
Hello,
u can use the following SQL SP for renamimg object..
exec sp_rename
example
sp_rename 'Hello', 'bye'
Thanks
Anil
Thanks & Regards
Anil Kumar Pandey
|