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

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

106

How to find the service pack installed? : sql server database administration

550

List types of tables in SQL Azure?

102

What were the latest updates to SQL Azure service?

How to concatenate two character strings together?

567

State the difference between union and union all?

521

How to get a list all databases on the sql server?

581

What is molap and its advantage? : sql server analysis services, ssas

545

what is the Ticketing tool used in Wipro technologies at Bangalore...???

7476

What is change data capture (cdc) in sql server 2008?

564

Are all views updatable ?

724

How do users use Report Builder with SQL Server data sources?

119

What is normalization process?

597

What are the different types of normalization?

621

How do I start sql server 2017?

528