Tuesday, September 7, 2010

Copy table structure

CREATE TABLE MY_NEW_TABLE AS
SELECT * FROM MY_EXISTING_TABLE WHERE 1=2;

above SQL will create new table MY_NEW_TABLE having structure same as MY_EXISTING_TABLE.

No comments:

Post a Comment