what command is used to create a table by copying the
structure of another table including constraints ?
- 6 Answers
- 14189 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
Why should I use postgresql?
How delete all records from table in sql?
What is cross join example?
How can you fetch common records from two tables?
What is the difference between function, procedure and package in pl/sql?
what is data integrity? : Sql dba
What is the command used to fetch first 5 characters of the string?
Does oracle roll back the transaction on an error?
how to convert character strings to numeric values? : Sql dba
What are the two virtual tables available at the time of database trigger execution?
What is rowtype?
What is a dirty read sql?
What are sql ddl commands?
What are the types of subqueries?
Why do we use subquery?
