Answer Posted / swetha
sp_renamedb ?oldname? , ?newname?
alter database ?databasename?
modify name = ?newdatabasename?
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is delete query?
Tell me the difference between clustered and non-clustered index?
How would you use user_constraints table in DB?
Can a table be moved to different filegroup?
what changed between the previous version of sql server and the current version? : Sql server database administration
Does transparent data encryption provide encryption when transmitting data across the network?
How to use values from other tables in update statements in ms sql server?
What is a domain constraint give an example?
What is merge statement?
How can windows applications connect to sql servers via odbc?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What is transaction server isolation?
How to modify the underlying query of an existing view?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
What the different topologies in which replication can be configured?