Hi
I don't want to change datas in a table which I use, but want to change only the table's name with T_SQL statments.
As you know there are SPs for rename SP or view, but I can not find such SP for table.
If you know about it,
or have the another good method to rename table,
tell me please.
Thanks for reading.sp_rename should work
eg
EXEC sp_rename 'customers', 'custs' (taken out of sp_rename in BOL)|||Now I do it as you said, then I can!
thanks.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment