T-SQL » Statements

SQL statements are used to access and manipulate data in a database.

SQL Data Manipulation Language (DML)
SQL (Structured Query Language) is a language used to execute queries. SQL Data Manipulation Language (DML) includes statements to retrieve, update, insert and delete records.

Important SQL DML Statements:

Statements	Description
SELECT	Retrieves data from a table.
UPDATE	Updates data in a table.
DELETE	Deletes data from a table.
INSERT INTO	Inserts new data into a table.

SQL Data Definition Language (DDL)
SQL Data Definition Language (DDL) permits database tables, indexes, properties and constraints to be created, altered or deleted.

Important SQL DDL Statements:

Statements	Description
CREATE TABLE	Creates a new table.
CREATE INDEX	Creates a new index.
ALTER TABLE	Modifies a table.
DROP TABLE	Deletes a table.
DROP INDEX	Deletes an index.

Primary links

T-SQL » Statements