SELECT TOP 0 * INTO tableB FROM tableA

How create table structure only from tableA to TableB if
TableA have some data?

Question Posted / anand.kv

Answer Posted / anand.kv

Is This Answer Correct ?

16 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain what is meant by replication of database?

1025

what is database replicaion? : Sql server database administration

1179

What is a hint?

985

What do you understand by a stored procedure?

1088

Explain linked server in sql?

1207

Can we insert data if clustered index is disabled?

937

What is difference between index and primary key?

1096

what is the sql equivaent of the dataset relation object ?

2015

Difference between drill down and drill through report.

946

What is merge statement?

1074

List out what other servers you can use with ssrs?

137

Explain what is lock escalation and what is its purpose?

925

What is an entity-relationship diagram (erd)?

1202

Explain the disadvantages/limitation of the cursor?

951

How to insert multiple rows with one insert statement in ms sql server?

1112