Use the built-in procedure sp_rename to changes the name of a user-created object in the database such as tables, indexes, columns, and alias data types in MS SQL Server. The following renames PinCode to ZipCode. EXEC sp_rename 'Employee.PinCode', 'Employee.ZipCode'; The above ALTER TABLE RENAME SQL script will change the Employee table as below. Here is the SQL query syntax to copy data from one table to another using INSERT INTO statement. INSERT INTO table1 (column1, column2, ...) select column1, column2, ... from table2 In the above query, we select column1, column2, from table2 and insert them into table1. Also Read : How to Update Multiple Columns in MySQL.