SQL Server database Operations

--Create a database
Create DATABASE Online test system
On
(
Name= Online examination System _data,
Filename= ' E:\DB\ online exam system _data.mdf ',
SIZE=5MB,
MAXSIZE=20MB,
filegrowth=5%
)
Log On (
Name= Online examination System _log,
Filename= ' E:\DB\ online exam system _log.ldf ',
SIZE=2MB,
MAXSIZE=10MB,
Filegrowth=1mb
)

Use [Online examination system]
GO
ALTER DATABASE online examination system
Add File
(
Name= Online examination system _DATA1,
Filename= ' E:\DB\ online exam system _data1.mdf ',
Size=2mb
)

Execution Result:

--View Current database status (single line comment)

/* Multiple lines
Comments */
Select DATABASEPROPERTYEX (' Online exam system ', ' status ')
As ' current database state '

Results:

--Delete Database

Drop DATABASE Online Exam system

SQL Server database Operations