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




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 ?    17 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 8 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

Post New Answer



More SQL Server Interview Questions

ow to bring suspect mode datbase online from scratch

0 Answers  


1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

11 Answers   Accenture,


Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,


Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,


What is the difference between truncate and delete statement?

6 Answers   CTS, CarrizalSoft Technologies,






What is better - 2nd Normal form or 3rd normal form? Why?

2 Answers   TCS, TPK,


1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  


How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  


What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,


what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 Answers  


what is Equity join?

2 Answers   ADP,


Normalization and denormalization

3 Answers   Wipro,






Categories