Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 renaming a table

Author  Topic 

mdhingra01
Posting Yak Master

179 Posts

Posted - 2004-09-01 : 09:42:18
I want to know if there is a command that will allow me to rename an existing table in my DB.

Thanks

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2004-09-01 : 09:54:27
sp_rename 'OldTableName' , 'NewTableNAme'


Go with the flow & have fun! Else fight the flow :)
Go to Top of Page

mdhingra01
Posting Yak Master

179 Posts

Posted - 2004-09-01 : 09:57:06
Awesome! Thanks.
Go to Top of Page
   

- Advertisement -