CREATE/ALTER/DROP Database

Create Database
USE [master]
GO
CREATE DATABASE [ravidb2]
CONTAINMENT = NONE
ON PRIMARY
( NAME = ‘ravidb2’, FILENAME = ‘C:\Program Files\Microsoft SQL Server\MSSQL14.MYSQLDB\MSSQL\DATA\ravidb2.mdf’ , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
LOG ON
( NAME = ‘ravidb2_log’, FILENAME = ‘C:\Program Files\Microsoft SQL Server\MSSQL14.MYSQLDB\MSSQL\DATA\ravidb2_log.ldf’ , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
GO

Rename Database
ALTER DATABASE MODIFY NAME = ;

Rename Data File
Alter DATABASE ravidb1;
MODIFY FILE ( NAME = ravidb1, NEWNAME = ravidb1_primary );

Change file location
Alter DATABASE ravidb1;
MODIFY FILE ( NAME = ravidb1_log, FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL14.MYSQLDB\MSSQL\LOG\ravidb1_log.ldf’);

Drop Database
USE master;
GO
DROP DATABASE ravidb2;
GO