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 functions and scalar functions?

0 Answers   EXL,

---

Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,

---

How to set database to be single_user in ms sql server?

0 Answers  

---

what are the Prerequisites for Replication?

1 Answers   IBM,

---

How check triggers in sql server?

0 Answers  

---

How to create a scrollable cursor with the scroll option?

0 Answers  

---

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

---

Which are the new data types introduced in sql server 2008?

0 Answers  

---

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  

---

How to create indexed view?

0 Answers  

---

How do I compare two values when one value(data type) is char and the other is an integer?

3 Answers  

---

What is meant by indexing?

0 Answers  

---