In the field for the Name value in the Properties window, type a new name for the table.
![sql server rename table sql server rename table](https://www.sqlshack.com/wp-content/uploads/2019/10/creating-a-sample-table-in-sql-server.png)
In Object Explorer, right-click the table you want to rename and choose Design from the shortcut menu. To Rename a column you can use the stored procedure sp_rename like following EXEC sp_rename 'TableName.OldColumnName', 'NewColumnName', 'COLUMN' ĮXEC sp_rename 'DataBaseName.TableName. Change Data Capture (CDC) is a powerful new feature in SQL Server 2008 (Enterprise edition only) that lets you easily and quickly capture all data changes made to tables in your database (its great for incrementally updating large data warehouses). Using SQL Server Management Studio To rename a table. (You may rename the old column first and then add the identity column with proper name too) Make sure that the original table name is correct. sprename Employee, emp Note: Make sure that the original table name is correct, and the new name has not been used with other database objects otherwise, it will raise an error. Use the sprename built-in stored procedure to rename a table in the SQL Server database. Use the sprename built-in stored procedure to rename a table in the SQL Server database. The following statement will rename Employee table to TempEmployee in the Oracle database. Add a new identity column, and remove the old column. Use the following ALTER TABLE RENAME script to rename table names in the MySQL, PostgreSQL, and SQLite database. It will show all tables in the small window and select the table you want to rename and then close. Right click with mouse on the the table and then select New Query.
![sql server rename table sql server rename table](http://technico.qnownow.com/files/2012/04/Rename_3.png)
Drop the current table and you may rename the table. First select the the table you want to rename in Server Explorer.
![sql server rename table sql server rename table](https://codingsight.com/wp-content/uploads/2021/02/5FactsAbout-MySQLINSERT_1_878х700-870x600.png)
Add all the contents to a new table with Identity column and copy data to that table. If you are using SQL Server Management Studio, right click on the database and select the Rename option and then rename the database. First of all, there is no direct way to do this.