Tuesday, January 26, 2010

Create a new table with same schema and data from an existing table

Create a new table with same schema and data from an existing table

SELECT * INTO NEWtABLEnAME FROM FROMtABLEnAME