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
- 16418 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 sql in java?
How long does it take to learn pl sql?
What is an ndf file?
How can we make an if statement within a select statement?
What is clause?
Compare sql & pl/sql
How do I write a sql query in pgadmin 4?
how to get help information from the server? : Sql dba
Explain sql data types?
Why do we use procedures in pl sql?
What does pl sql developer do?
Write the command to remove all players named sachin from the players table.
How do I add a database to sql?
What are the basic sql commands?
What is the sql case statement?
