Technical Guide
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment