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 the difference between join and inner join?

0 Answers  

---

Can you explain what are commit and rollback in sql?

0 Answers  

---

What is the maximum size per database for sql server express?

0 Answers  

---

What is the difference between count () and rowcount ()?

0 Answers  

---

What is a performance monitor?

0 Answers  

---

What are different types of data sources?

0 Answers  

---

What is the use of floor function in sql server?

0 Answers  

---

How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

---

What's the difference between a primary key and a unique key?

4 Answers  

---

Explain go command in sql server?

0 Answers  

---

How to filter records of table in SQL SERVER?

0 Answers   Petranics Solutions,

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

0 Answers  

---