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

What is the log shipping?

952

What is dirty read?

1041

How to convert binary strings into integers in ms sql server?

962

State a few properties of relational databases?

1060

Explain the etl (extraction, transformation, and loading)?

937

What are rest-style architecture's?

170

Explain ranking functions?

991

What are the differences between user defined functions and stored procedures?

1004

How to create a user name in a database?

993

How adventureworkslt tables are related?

879

How much is a sql server license?

900

What are the drawbacks of reporting in ssrs?

141

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1059

What is the distinction amongst delete and truncate?

1000

What are the two modes of authentication in sql server?

979