Re: How to rename a table in a database?

Hi Paul,

For SQL Server, there's always sp_rename [1].
Don't know about other DBMSs.

Kim

[1]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref
/ts_sp_ra-rz_3ns5.asp

> -----Original Message-----
> From: OLEDB_DEV [mailto:[email protected]] On
> Behalf Of Paul Selormey
> Sent: den 17 april 2003 08:09
> To: [email protected]
> Subject: How to rename a table in a database?
>
>
> Hello All,
>
> Is there a way by SQL statement, if any, to rename a table in
> a database? Or there any vendor specific way of doing it?
>
> Best regards,
> Paul.
>
>
> _________________________________________________________________
> MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus

You can read messages from the OLEDB_DEV archive, unsubscribe from
OLEDB_DEV, or subscribe to other DevelopMentor lists at
http://discuss.develop.com.

You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.