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

What is index in an assignment?

962

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1070

What is de-normalization in sql database administration? Give examples?

989

What is "scheduled jobs" or "scheduled tasks"?

985

What are the basic features of a trigger in ms sql server?

1205

Why we should not use triggers?

970

How to create view in stored procedure sql server?

1025

Explain about nested stored procedure?

1041

What command would you use to add a column to a table in sql server?

1318

Write a query to find 5th highest amount paid from the customer table.

939

How to delete a login name in ms sql server?

1082

What is an indexing technique?

944

How to drop existing indexes in ms sql server?

1076

What are the recovery models for a database?

1114

How many cores do I need for sql server 2016?

906