Click the "Home" tab on the ribbon. Click the "Insert" arrow button in the Cells group to open the list of options. Click "Insert Table Columns to the Left." The columns to the right will shift.

explicitly identify each table with a specific command. You can insert specific values into a table with an Identity column, but, to do so, you must first set the IDENTITY_INSERT value to ON.