change table name

What is the syntax for changing a table name? Can not find it in my
reference books.
Thanks
Laura KNever mind. By brain is turned off. I did a search. Found it.
Laura K
"Laura K" <klkazanAT@.ATcharter.net> wrote in message
news:uqrkEU$WFHA.3464@.TK2MSFTNGP10.phx.gbl...
> What is the syntax for changing a table name? Can not find it in my
> reference books.
> Thanks
> Laura K
>|||Hi !
Try This
use northwind
EXEC sp_rename 'customers', 'custs'
select * from custs--for cross checking
Regards
Swati Zingade
*** Sent via Developersdex http://www.examnotes.net ***