SELECT TOP 0* INTO tabname2 FROM tabname1

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

Question Posted / jaydev

Answer Posted / jaydev

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to find out what is the default collation in a database?

1178

What is the use of keyword with encryption. Create a store procedure with encryption?

998

Is the order of columns in the set clause important in ms sql server?

1011

What are a scheduled jobs or what is a scheduled tasks?

944

What is the impact on other user sessions when creating indexes?

963

What are Spatial data types in SQL Server 2008

1072

What is a benefit of using an after insert trigger over using a before insert trigger?

1033

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

1079

Describe and explain about SQL native client?

1157

Explain about system stored procedure?

1076

what method you can use to reduce the overhead of Reporting Services data sources?

268

How is SQL Azure different than SQL server?

225

How many levels of sp nesting is possible?

1099

How to find Duplicate Records In table?

1071

How do you run a trace?

946