SQL Database

Create database

CREATE DATABASE database_name

Drop database

DROP DATABASE database_name

Backup Database

BACKUP DATABASE database_name
TO DISK = 'file_path'

Create Table

CREATE TABLE table_name(
    col1 datatype constrain,
    col2 datatype constrain,
    col3 datatype constrain,
    col4 datatype constrain,
    .
    .
    .
)

Constrain

• NOT NULL
• UNIQUE
• PRIMARY KEY
• FORIENGN KEY (column_name) REFERENCES table_name(column_name)
• CHECK
• DEFAULT
• INDEX

Drop Table

DROP TABLE table_name

Alter Table

Add Column

ALTER TABLE table_name
ADD column_name datatype

Drop Column

ALTER TABLE table_name
DROP COLUMN column_name

Modify Column

ALTER TABLE table_name
ALTER COLUMN column_name datatype

Create View

CREATE VIEW AS
SELECT * FROM table_name WHERE Condition