what command is used to create a table by copying the
structure of another table including constraints ?
Answer Posted / a.jyothsna
I know copying the structure of one table but not the
constraints also:
create table newtablename as
select * from oldtablename;
with the above query total data will also be copied.
But to copy only the structure.
create table newtablename as
select * from oldtablename
where 1=2;
Is This Answer Correct ? | 20 Yes | 6 No |
Post New Answer View All Answers
What are the benefits of triggers?
Name the different types of indexes in sql and define them.
How do I find duplicates in two columns?
What is nosql example?
What is range partitioning?
What is not in sql?
How can you fetch first 5 characters of the string?
Is sql port 1433 encrypted?
How to select 10 records from a table?
Which sql statement is used to delete data from a database?
Can a primary key be a foreign key?
Inline the values in PL/SQL, what does it mean.?
How to display Row Number with Records in Oracle SQL Plus?
What information is needed to connect sql*plus an oracle server?
How to pipe multiline string to isql?