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 are the steps you will take to improve the performance of a poor performing query?

0 Answers  

What does it mean to normalize data?

0 Answers  

What samples and sample databases are provided by microsoft?

0 Answers  

What are subqueries in sql server? Explain its properties.

0 Answers  

How to modify the underlying query of an existing view?

0 Answers  

how to find nth highest salary

103 Answers   Cognizant, IBM, NexGen, Oracle,

What is the use of custom fields in report?

0 Answers  

How to locate and take substrings with charindex() and substring() functions?

0 Answers  

What does sql server mean?

0 Answers  

Which is faster statement or preparedstatement?

0 Answers  

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  

What is log shipping?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories