what command is used to create a table by copying the
structure of another table including constraints ?
- 6 Answers
- 14244 Views
- CMC, eicc, I also Faced
- E-Mail Answers
Answer Posted / thirumal
select * into <new table name> from < old tablename> where
<any false condition>
ex: new table name "emp"
Old table name "dept"
select * into emp from dept where 2=5
then it will display only the structure of the old
table,not the data
| Is This Answer Correct ? | 3 Yes | 15 No |
Post New Answer View All Answers
Can 2 queries be executed simultaneously in a distributed database system?
What is a .db file?
How subquery works in sql?
Explain ddl statements in pl/sql?
what is the difference between primary key and unique key? : Sql dba
What is snowflake sql?
What are different types of indexes?
How can you fetch first 5 characters of the string?
Why truncate is faster than delete?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is the limitation on the block size of pl/sql?
How to add a column ‘salary’ to a table employee_details?
How many clustered indexes can be created on a table?
what is 'mysqlcheck'? : Sql dba
What is duration in sql profiler trace?
