SQL Query to copy structure of one table to another table in SQL Server.
Syntax: Select * into Newtable from Oldtable where 1=2
Ex: Select * into emp1 from emp where 1=2
The above query copies only structure(not data) of emp to emp1.
SQL Query to get structure of table
Showing posts with label How to Copy Structure of One Table into Another Table in sql server. Show all posts
Showing posts with label How to Copy Structure of One Table into Another Table in sql server. Show all posts
Subscribe to:
Comments (Atom)
