Answer / mohammadali.info

CREATE TABLE new_table
AS (SELECT * FROM old_table WHERE 1=2);

For example:

CREATE TABLE suppliers
AS (SELECT * FROM companies WHERE 1=2);

This would create a new table called suppliers that included all columns from the companies table, but no data from the companies table.

Answer / amit kumar sharma

Select * into newTable From oldTable where 1=2

The where condition 1=2 will never get true, so only the
column of table will appear and get copied to newTable.

If we remove the where condition table with data will copy
to newtable.

Answer / arun

Select top 0
into newtable
from oldtable

What is normalization and what are the advantages of it?

0 Answers  

---

What is the difference between resultset and resultsetmetadata?

0 Answers  

---

What are the different authentication modes in sql server? How can it be changed?

0 Answers  

---

Can you please explain the difference between primary keys and foreign keys?

0 Answers  

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

Does index slows down insert statements?

0 Answers  

---

What is the difference between count and distinct count?

0 Answers  

---

What is an expression in ms sql server?

0 Answers  

---

How to restore performance issues and how to check?

0 Answers  

---

Can I remove the default constraint columns in SQL SERVER?

5 Answers   Value Labs,

---

What are the benefits and tasks of object explorer? : sql server management studio

0 Answers  

---

Explain transaction server distributed transaction?

0 Answers  

---