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

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

Question Posted / anand.kv

4 Answers
7262 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / anand.kv

SELECT TOP 0 * INTO tableB FROM tableA

Is This Answer Correct ?

16 Yes

0 No

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

Answer / sunny

to copy only the structure
select * into table2 from table1 where 1=2
to copy the table along with the records
select * into table2 from table1 where 1=1

Is This Answer Correct ?

12 Yes

0 No

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

Answer / karthik

Create table emp1
as
select * from emp
where 1=2

It will give the structure of the table.

Is This Answer Correct ?

3 Yes

3 No

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

Answer / mits

Create table newtablename
from oldtablename
where 1=2

Is This Answer Correct ?

4 Yes

6 No

Post New Answer