what command is used to create a table by copying the
structure of another table?
- 7 Answers
- 13671 Views
- I also Faced
- E-Mail Answers
Answer Posted / naik
select * into oldtable from newtable where oldtable
=newtable
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How do I view views in sql server?
What purpose does the model database server?
Can you pass expressions to function parameters?
What is sql server replication? : sql server replication
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is a rollup clause?
What are the restrictions applicable while creating views? : SQL Server Architecture
What do we have to check in database testing?
What are the ways available in sql server to execute sql statements?
What is partition in sql server?
What is encryption key?
What are the types of table?
what is the difference between count(*) and count(1) ?
Can we use max in where clause?
What is a performance monitor?
