Numeric

• INT

• DECIMAL

• FLOAT

• REAL

• BIT

• TINYINT

• SMALLINT

• BIGINT

• NUMERIC

Character

• CHAR

• VARCHAR

• TEXT

• TINYTEXT

• MEDIUMTEXT

• LONGTEXT

Date and Time

• DATE

• TIME

• DATETIME

• TIMESTAMP

• YEAR

Boolean

• BIT

• BOOLEAN

Constraints

• PRIMARY KEY

• FOREIGN KEY

• UNIQUE

• NOT NULL

• CHECK

• DEFAULT

Views

• CREATE VIEW

• ALTER VIEW

• DROP VIEW

Transactions

• BEGIN TRANSACTION

• COMMIT

• ROLLBACK

• SAVEPOINT

Indexes

• Clustered indexes

• Non-clustered indexes

• Composite indexes