If we want to copy the structure only of table

Satyapriyanayak
Posted by Satyapriyanayak under Sql Server category on | Points: 40 | Views : 639
SELECT TOP 0 * INTO newtable FROM oldtable

SELECT TOP 0 * INTO employee1 FROM employee

SELECT * INTO newTable FROM oldTable WHERE 0 = 1

Comments or Responses

Login to post response