View Single Post
 
Old January 4th, 2005, 07:12 AM
maneeshgautam maneeshgautam is offline
Registered User
 
Join Date: Dec 2004
Location: Chennai, TN, India.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to maneeshgautam Send a message via MSN to maneeshgautam Send a message via Yahoo to maneeshgautam
Default

Hi Kumar,

Please try this,

CREATE TABLE NEWTABLENAME AS
SELECT * FROM OLDTABLENAME WHERE 1=2;

Thanks and regards
-Maneesh