Answer / visala

sp_renamedb 'oldname','newname'

alter database <databasename>
modify name=<newdatabasename>

Answer / swetha

sp_renamedb ?oldname? , ?newname?

alter database ?databasename?
modify name = ?newdatabasename?

Answer / latha sree

sp_renamedb ?oldname? , ?newname?

Answer / 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

Answer / babuli

To rename a SQL database follow the these seps:

1. Alter database to single user mode. So that all the
active connection will be terminated. (Database properties
-> options > single usermode)
2. Then rename the database using sp_renamedb oldname, newname

I have to display ten columns values from diffrent ten tables. how many joins are require?

10 Answers   CarrizalSoft Technologies, HCL,

wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

1 Answers   Idea,

What is difference between group by and having?

0 Answers  

from the table display the 2nd highest salary? and also the least 2nd salay?

8 Answers  

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  

what is trigger

1 Answers   CarrizalSoft Technologies, NIIT,

explain the type of contraints

3 Answers  

What are the four main query statements?

7 Answers   Wipro,

What is importing utility?

0 Answers  

Explain trigger and its types?

0 Answers  

What is the difference between commit and rollback?

0 Answers  

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 Answers