Create table newtablename from oldtablename where 1=2

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

Question Posted / mits

Answer Posted / mits

Create table newtablename
from oldtablename
where 1=2

Is This Answer Correct ?

4 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1032

What happens if you insert a duplicate key for the primary key column in ms sql server?

977

Explain powershell included in sql server 2008?

1058

What is the function of sql server agent windows service?

1097

What is the difference between clustered and a non-clustered index?

1029

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

1077

What happens if strings are casted into wrong code pages in ms sql server?

1113

What does it mean to normalize a database and why would you do it?

980

What is apply operator in sql?

1013

What is the query and subquery?

1078

Explain linked server in sql?

1225

What is multilevel indexing?

929

What do you think of this implementation? Can this be implemented better?

945

How to attach adventureworkslt physical files to the server?

1106

How to fine-tune reports?

268