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 are sub reports?

190

What is hot add cpu in sql server 2008?

892

What is a hint?

945

How to see existing views in ms sql server?

996

What is a database in ms sql server?

1000

How to update values in a table with update statements in ms sql server?

967

What is sleeping status in sql server?

989

What command must you use to include the not null constraint after a table has already been created?

1068

How do you set a trace flag in sql server?

1004

Explain the properties of subqueries in sql server?

1030

What is the use of floor function in sql server?

1033

How can windows applications connect to sql servers via odbc?

1073

What is the difference between functions and scalar functions?

1134

Is t sql the same as sql server?

925

What is difference between unique and primary key?

863