create table table_name as select * from another

what command is used to create a table by copying the
structure of another table?

Question Posted / kunal sain

Answer Posted / kunal sain

create table table_name
as select * from another_table
where 1>2;

Is This Answer Correct ?

7 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Explain DBCC?

562

What are locks in sql?

531

Do you know how to send email from database?

542

How to download and install sql server 2005 books online?

534

How to insert and update data into a table with "insert" and "update" statements?

502

What is the cartesian product of table?

537

Define compound operators?

527

What will be the maximum number of indexes per table?

523

What is the full form of dql?

503

What happens if ntwdblib.dll is missing on your machine?

626

What is a join in sql?

576

Is there any difference between the primary key and unique key?

561

How to identify current user in ssrs report?

238

List out some of the requirements to set up a sql server failover cluster?

539

What is a virtual table in sql?

543