SQL Query to Return Information About all Databases in SQLServer

Check this post for sqlserver faqs


SQL Query to Return Information About all Databases in SQL Server


exec sp_helpdb


Check here for SQL Query to delete multiple databases in sqlserver
SQL Query to rename database in sqlserver.
Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

SQL Query to Delete Multiple Databases in SQL Server-SQL Queries

Check This Post for sql query to delete single database in sql server

SQL Query to drop multiple databases in sqlserver.


Syntax:DROP DATABASE databasename1, databasename2

Example:Drop Database Lakshmi1,Lakshmi2

Check This SQL Query to Rename Database
Check this post for SQL Query To Find Minimum Salary From Emp Table in SQLSERVER.
Sql query to find highest salary in sqlserver.
Check this post to get 2nd and 3rd Highest salary
SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer
Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

SQL Query to Delete Database in Sql Server-SQL Queries in SQLServer

Check this post for SqlServer Faqs

SQL Query to Drop Database in Sql Server


Syntax:DROP DATABASE databasename

Example:drop database lakshmi

Check This SQL Query to Rename Database

Check this post for SQL Query To Find Minimum Salary From Emp Table in SQLSERVER.
Sql query to find highest salary in sqlserver.
Check this post to get 2nd and 3rd Highest salary
SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer
Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

SQL Query to Rename Database in SQL Server

SQL Query to rename database.

Syntax: sp_renamedb 'olddatabasename','newdatabasename'

Example: sp_renamedb 'Lakshmi','Laxmi'

Check this post for SQL Query To Find Minimum Salary From Emp Table in SQLSERVER.
Sql query to find highest salary in sqlserver.
Check this post to get 2nd and 3rd Highest salary
SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer
Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs