SQL Query Basics

Database

In Microsoft SQL Server Management Studio You can execute single command by selecting it and pressing F5

SQL Keywords are not case Sensitive

Create Database

create database MyDatabase

Select Database

Initially master database is selected

use MyDatabase

Rename Database

Here sp means Stored Procedure (Here old name is MyDatabase & new name is DBDatabase)

sp_renamedb MyDatabase,DBDatabase