Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How can I create a table from another table without copying any values from the old table?

Question Posted / mohammadali.info

Answers were Sorted based on User's Feedback



How can I create a table from another table without copying any values from the old table?..

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.

Is This Answer Correct ?    7 Yes 3 No

How can I create a table from another table without copying any values from the old 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.

Is This Answer Correct ?    3 Yes 0 No

How can I create a table from another table without copying any values from the old table?..

Answer / arun

Select top 0
into newtable
from oldtable

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What is rank function?

0 Answers  

What is the use of RDBMS?

0 Answers   Wipro,

What is a mutating table error and how can you get around it?

0 Answers  

What is optimization and its types?

0 Answers  

How many types of built in functions are there in sql server 2012?

0 Answers  

What is referential integrity? What are the advantages of it?

4 Answers   Descon, Digital Domain,

How to rebuild all indexes on a single table?

0 Answers  

Define constraints and give an example of their use?

0 Answers  

What is the difference between a unique key and primary key?

0 Answers  

What is SubQuery in SQL Server 2008

0 Answers   HCL,

Which are new data types introduced in sql server 2008?

0 Answers  

How to get all stored procedures in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories