SELECT * INTO tabname1 FROM tabname2 WHERE 1<>2 (TO copy only the s

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

Question Posted / narsing

Answer Posted / narsing

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

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Describe how to use linked server?

1082

Difference between drill down and drill through report.

1007

What is the command to change the recovery model?

1093

Explain transaction isolation levels in sql server?

1185

What are the characteristics of modern DBMS?

1140

What are the reporting services components?

144

What program is used to store the data source file?

1006

Do comments need to go in a special place in sql server 2005?

916

What is correlated subquery in sql server?

1127

What is the sql case statement used for?

1133

Explain the functionalities that views support?

1162

How do you troubleshoot errors in a SQL Server Agent Job?

1111

What are extended events in sql server?

1009

What is policy based management (pbm)? : sql server database administration

1032

What are the differences between stored procedure and view in sql server?

1319