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

How to backup SQL Server Reporting Services ?

141

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3830

What are the authentication modes in sql server? How can it be changed?

1068

Explain transaction server isolation?

984

Explain foreign key in sql server?

981

how you can deploy an ssrs report?

174

What is transaction server distributed transaction?

990

What is a user-defined function in the sql server and what is its advantage?

1052

What does it mean to manipulate data?

953

what is a schema in sql server 2005? : Sql server database administration

963

What is thr feature of change data capture?

924

What is the security principal at the server level that represents your session?

973

What is the difference between a primary key and a unique key? Are they the same?

1020

How do you delete duplicate records in sql server?

1010

Explain about integration services of Microsoft SQL server?

993