Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Rename a table

2 Posts 2 Posters 0 Views 1 Watching

A Offline
A Offline
Andy M

wrote on last edited by

#1

How do I rename a table in SQL Server 2000? I mean by script, I can do it easily enough in the Enterprise Manager. Cheers, Andy
C 1 Reply Last reply

0
A Andy M

How do I rename a table in SQL Server 2000? I mean by script, I can do it easily enough in the Enterprise Manager. Cheers, Andy
C Offline
C Offline
Colin Angus Mackay

wrote on last edited by

#2

You can use the sp_rename[^] stored procedure in order to rename tables, views, stored procedures and so on.

My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
1 Reply Last reply

0

Log in to reply