SELECT * INTO tabname1 FROM tabname2 WHERE 1=2 (TO copy only the structur

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

Question Posted / hokar

Answer Posted / hokar

SELECT * INTO tabname1 FROM tabname2 WHERE 1=2 (TO copy
only the structure)

Is This Answer Correct ?

18 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What do you mean by an execution plan? How would you view it?

905

What is the difference between mysql and mysqli?

1167

Can we hide the definition of a stored procedure from a use?

1200

What is the Difference Between Primary and Foreign Key?

988

How does stuff differ from the replace function?

993

Can the query output be sorted by multiple columns in ms sql server?

965

How to perform key word search in tables?

948

Describe how to use linked server?

993

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1951

What is “asynchronous” communication in sql server service broker?

1015

How do I view a script in sql server?

1027

Can you index views?

888

Why we need sql server?

948

Scalability, Availability, Integration with internet, etc.)?

2863

What is the purpose of a table?

945