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
- 16179 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
Is sql microsoft?
What is trigger in sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
What is the difference between microsoft sql and mysql?
What is bulk compiling in pl/sql.?
how would concatenate strings in mysql? : Sql dba
What is AUTH_ID and AUTH_USER in pl/sql ?
What do you understand by exception handling in pl/sql?
Why do we use procedures in sql?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What if we write return in procedure?
What does select * from mean in sql?
What is the clause we need to add in function body to return variable?
How can we implement rollback or commit statement in a trigger?
How many types of triggers exist in pl/sql?
