Monday, January 2, 2012

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.

2 comments:

  1. Nice one...
    I think its Rename instead of remane in title-----"How to remane a Table in Sql Server" :)

    ReplyDelete