bugl
bugl
HomeLearnPatternsSearch
HomeLearnPatternsSearch

Loading lesson path

Learn/SQL/SQL References
SQL•SQL References

SQL Keywords Reference

Concept visual

SQL Keywords Reference

Pointer walk
two pointers
leftright102132436485116
left=0
right=6
1
3

Start at both ends

This SQL keywords reference contains the reserved words in SQL.

SQL Keywords

Keyword

Description

Add

Adds a column in an existing table

Add Constraint

Adds a constraint after a table is already created

All

Returns true if all of the subquery values meet the condition

Alter

Adds, deletes, or modifies columns in a table, or changes the data type of a column in a table

Alter Column

Changes the data type of a column in a table

Alter Table

Adds, deletes, or modifies columns in a table

Alter View

Updates a view

And

Only includes rows where both conditions is true

Any

Returns true if any of the subquery values meet the condition AS Renames a column or table with an alias

Asc

Sorts the result set in ascending order

Backup Database

Creates a back up of an existing database

Between

Selects values within a given range

Case

Creates different outputs based on conditions

Check

A constraint that limits the value that can be placed in a column

Column

Changes the data type of a column or deletes a column in a table

Previous

SQL Data Types for MySQL, SQL Server, and MS Access

Next

SQL ADD Keyword