Interested to Buy Any Domain ? << Click Here >> for more details...
what command is used to create a table by copying the
structure of another table including constraints ?
- 6 Answers
- 16425 Views
- CMC, eicc, I also Faced
- E-Mail Answers
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 is dml statement?
what are date and time intervals? : Sql dba
What is sql analyzer?
What is sql prepared statement?
How much does sqlite cost?
What is use of term?
How bulk collect improves performance?
What are inner outer left and right joins in sql?
What problem one might face while writing log information to a data-base table in pl/sql?
How many types of relationship are there?
What are the advantages of pl sql?
Why do we create views in sql?
what are the advantages of mysql in comparison to oracle? : Sql dba
what happens if you no create privilege in a database? : Sql dba
What is substitution variable?
