Wednesday, April 28, 2010

Copy table with data and structure in SQL


SELECT *
INTO new_table_name FROM old_tablename



above statement copy the table(existing table) data and structure into new table

No comments:

Post a Comment