what command is used to create a table by copying the structure of another tab

what command is used to create a table by copying the
structure of another table?

Question Posted / guest

Answers were Sorted based on User's Feedback

what command is used to create a table by copying the structure of another table?..

Answer / hokar

SELECT * INTO tabname1 FROM tabname2 WHERE 1=2 (TO copy
only the structure)

Is This Answer Correct ?

18 Yes

4 No

what command is used to create a table by copying the structure of another table?..

Answer / pradip jain

SELECT * INTO tblNew FROM tblOld WHERE 1=2

Is This Answer Correct ?

7 Yes

0 No

what command is used to create a table by copying the structure of another table?..

Answer / kumar.t

Select * into newnew1 from newnew WHere 1=2

Is This Answer Correct ?

4 Yes

0 No

what command is used to create a table by copying the structure of another table?..

Answer / jaydev

SELECT TOP 0* INTO tabname2 FROM tabname1

Is This Answer Correct ?

5 Yes

3 No

what command is used to create a table by copying the structure of another table?..

Answer / naik

select * into oldtable from newtable where oldtable
=newtable

Is This Answer Correct ?

2 Yes

1 No

what command is used to create a table by copying the structure of another table?..

Answer / kunal sain

create table table_name
as select * from another_table
where 1>2;

Is This Answer Correct ?

7 Yes

9 No

what command is used to create a table by copying the structure of another table?..

Answer / narsing

SELECT * INTO tabname1 FROM tabname2 WHERE 1<>2 (TO copy
only the structure)

Is This Answer Correct ?

0 Yes

3 No