Translate

Monday, 29 May 2017

SELECT * INTO


I have a table and I want to create the same structure and copy all the data from this table .
All the structure are same but the table name is different .
Am using this query.
As a result I have 2 tables having same table structure and same data with different table name .
Here My existing table is tblOld   and my new table is tblNew  .

SELECT * INTO tblNew  FROM tblOld ;

After run this query I got same structure of tblNew   as of tblOld .

No comments:

Post a Comment