The "SELECT INTO" technique will create a table with the same columns but doesn't reproduce the keys, constraints, and defaults.
This query is used to create a dupliate table with same columns and data
Code:
This query is used to create a dupliate table with same columns and data
Code:
select * into newtable from oldtable
0 comments:
Post a Comment