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