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

What is the difference between primary key and unique constraints?

948

Explain the relational database management system (rdbms)?

1081

What is the usage of the sign function?

1091

Differentiate between a local and a global temporary table?

946

What are the different kinds of ssrs reports?

214

Explain indexes disadvantages?

1072

What is sub-query in sql server?

1195

How to delete a login name in ms sql server?

1061

Does partitioning improve performance?

961

What is cross join in sql server joins?

1128

How many types of schemas are there?

1036

What are the advantages to use stored procedures?

1098

What are various aggregate functions that are available?

971

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

1000

how can you attach more than 20 ldf files in sql server

1990