Explore Courses Blog Tutorials Interview Questions
0 votes
in SQL by (20.3k points)

I know the statement:

create table xyz_new as select * from xyz;

Which copies the structure and the data, but what if I just want the structure?

1 Answer

0 votes
by (40.7k points)
edited by

You can use Where clause because it won’t select any rows:

create table xyz_new as select * from xyz where 1=0;

Are you interested in learning SQL from the basics! Refer to this video on SQL provided by Intellipaat:

Note: When you are creating a copy of an ORACLE table without copying the data then the things such as: indexes, triggers, sequences, materialized view logs, things that don’t handle partitions and some constraints also won't be copied to the new table from the original table. 

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.5k answers


108k users

Browse Categories