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 do we use to rename a db?

Answer Posted / karthick.r

sp_rename olddatabasename newdatabasename
for eg
sp_rename prodetails empdetails;


in this eg the name of the prodetails is changed into
empdetails using above command

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is unique and xaml nonclustered index

1010


How to invoke a trigger on demand?

1056


What are types of subqueries?

1021


Explain how to send email from sql database?

1001


Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

894


Explain cursor as data base object?

999


Does index speed up select statements?

992


What the difference between UNION and UNIONALL?

1003


What is normalization? What number of normalization shapes are there?

1073


What is attribute hierarchy? : sql server analysis services, ssas

985


What is the minimum recommended amount of ram for sql server 2012 enterprise?

906


Explain what role entity and relationship play in an ER diagram.

1043


What is difference between equi join and natural join?

988


Can we use where clause in union?

1026


What is the Main Difference between ACCESS and SQL SERVER?

1085