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
- 16389 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 transaction control language (tcl)?
How do you truncate?
what is the difference between primary key and unique key? : Sql dba
What is a native sql query?
Explain what is sql*plus?
What is primary key and unique key?
What is group function in sql?
Why schema is used in sql?
What is the difference between join and natural join?
what is top in tsql? : Transact sql
Which sql most popular?
Describe sql comments?
What is the syntax to add a record to a table?
How many commands are there in sql?
What are inner outer left and right joins in sql?
