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
- 16439 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
How do sql databases work?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What does plv msg allows you to do?
explain normalization concept? : Sql dba
Can a trigger call a stored procedure?
What is mutating error?
What are pl/sql cursors?
What makes a good primary key?
What are instead of triggers?
Where is sql database stored?
What is PL/SQL Records?
Can a select statement fire a trigger?
How does a self join work?
What is compound trigger?
what is the difference between inner and outer join? Explain with example. : Sql dba
