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

How to configure odbc dsn with different port numbers?

1151

Explain left outer join and right outer join?

1091

What are the advantages to use stored procedures?

1179

What are the different types of sub-queries?

1087

What is Extended user-defined?

1029

Why do we need different type of parameter?

1108

What stored by the tempdb ? : sql server database administration

1097

How to delete duplicate rows in sql server?

1152

How to check if a table is being used in sql server?

1009

What is the datatype of rowid?

963

Explain time data type in sal server 2008?

966

Explain in brief about Microsoft SQL server?

1173

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

1080

Explain what are page splits? : SQL Server Architecture

1119

What is a transact-sql statement batch in ms sql server?

1071