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 are the advantages of using stored procedures in sql server?

954

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2017

How can we get count of the number of records in a table?

899

Explain what is log shipping?

1073

What is a dbms wizard?

969

What is a hint?

934

Do you know the policy based administration feature of sql server 2008?

905

Are all views updatable ?

1103

What are scalar functions?

947

When should you use an instead of trigger?

918

What is the usage of the sign function?

998

What is linked report?

119

Explain few examples of RDBMS?

974

Do you know what is sql service broker?

995

What are the types of stored procedures in an sql server?

934