what command is used to create a table by copying the
structure of another table including constraints ?
- 6 Answers
- 15163 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
What is difference between nchar and nvarchar?
In what condition is it good to disable a trigger?
Which operator is used in query for pattern matching?
what is timestamp in mysql? : Sql dba
Can a table contain multiple foreign key’s?
What is bulk collect in pl sql?
What is input buffer in sql*plus?
What is difference between sql function and stored procedure?
what is the difference between a having clause and a where clause? : Sql dba
Can we rollback delete command?
What is the current version of postgresql?
What is the command used to fetch first 5 characters of the string?
what is commit? : Sql dba
How long it takes to learn pl sql?
Which table is left in join?
