How to rename a Table in Sql Server

SQL Basic Concepts SQL Server
vivekjohari3 Comments on How to rename a Table in Sql Server
To rename a column in a SQL Table following command can be reused:
SP_RENAME  ‘old table name’, ‘New table name’

For example, if we want to rename the table from employee to employeemaster, following command can be used.

SP_RENAME  ’employee’, ’employeemaster’

This command will rename the table from employee to employeemaster.

Related Posts

Advantages & Disadvantages of SQL Trigger

vivekjohari

AVG() function in SQL Server

vivekjohari

Different ways to create a table and insert data into the table

vivekjohari

3 thoughts on “How to rename a Table in Sql Server”

  3. Pingback: Lithuanian translator

Leave a Reply