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...

what command is used to create a table by copying the
structure of another table?

Answer Posted / kunal sain

create table table_name
as select * from another_table
where 1>2;

Is This Answer Correct ?    7 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define full outer join in sql server joins?

994


What is the fillfactor concept in indexes?

986


How to perform backup for certificates in sql server? : sql server security

1092


Why transaction is important?

975


What is cte (common table expression)?

1032


Can select statements be used on views in ms sql server?

1065


How to use the inserted and deleted pseudo tables?

961


What is difference between equi join and inner join?

950


What is cached report?

143


what data regions are and what are the different data regions?

141


What is 2nf normalization?

1028


in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1066


Explain the collation?

1111


When you should use a low fill factor?

993


What is sql view?

1038