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

How can I enforce to use particular index?

1 Answers   Symphony,

---

What is the default schema of your login session in ms sql server?

0 Answers  

---

Diffrences between sql server 2000 vs 2005

2 Answers   Thomson Reuters,

---

How do I find the query plan in sql server?

0 Answers  

---

Explain a differential backup?

0 Answers  

---

What is exporting and importing utility?

0 Answers  

---

How to use subqueries in the from clause in ms sql server?

0 Answers  

---

What is the difference between mysql and mysqli?

0 Answers   HCL,

---

What are the five characteristics of good data?

0 Answers  

---

What are the differences between UNION and JOINS?

3 Answers   CarrizalSoft Technologies,

---

Mention the differences between local and global temporary tables.

0 Answers  

---

How to execute a sql statement using odbc_exec()?

0 Answers  

---