ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
KeywordDescription
3
ADDAdds a column in an existing table
4
ADD CONSTRAINTAdds a constraint after a table is already created
5
ALLReturns true if all of the subquery values meet the condition
6
ALTERAdds, deletes, or modifies columns in a table, or changes the data type of a column in a table
7
ALTER COLUMNChanges the data type of a column in a table
8
ALTER TABLEAdds, deletes, or modifies columns in a table
9
ANDOnly includes rows where both conditions is true
10
ANYReturns true if any of the subquery values meet the condition
11
ASRenames a column or table with an alias
12
ASCSorts the result set in ascending order
13
BACKUP DATABASECreates a back up of an existing database
14
BETWEENSelects values within a given range
15
CASECreates different outputs based on conditions
16
CHECKA constraint that limits the value that can be placed in a column
17
COLUMNChanges the data type of a column or deletes a column in a table
18
CONSTRAINTAdds or deletes a constraint
19
CREATECreates a database, index, view, table, or procedure
20
CREATE DATABASECreates a new SQL database
21
CREATE INDEXCreates an index on a table (allows duplicate values)
22
CREATE OR REPLACE VIEWUpdates a view
23
CREATE TABLECreates a new table in the database
24
CREATE PROCEDURECreates a stored procedure
25
CREATE UNIQUE INDEXCreates a unique index on a table (no duplicate values)
26
CREATE VIEWCreates a view based on the result set of a SELECT statement
27
DATABASECreates or deletes an SQL database
28
DEFAULTA constraint that provides a default value for a column
29
DELETEDeletes rows from a table
30
DESCSorts the result set in descending order
31
DISTINCTSelects only distinct (different) values
32
DROPDeletes a column, constraint, database, index, table, or view
33
DROP COLUMNDeletes a column in a table
34
DROP CONSTRAINTDeletes a UNIQUE, PRIMARY KEY, FOREIGN KEY, or CHECK constraint
35
DROP DATABASEDeletes an existing SQL database
36
DROP DEFAULTDeletes a DEFAULT constraint
37
DROP INDEXDeletes an index in a table
38
DROP TABLEDeletes an existing table in the database
39
DROP VIEWDeletes a view
40
EXECExecutes a stored procedure
41
EXISTSTests for the existence of any record in a subquery
42
FOREIGN KEYA constraint that is a key used to link two tables together
43
FROMSpecifies which table to select or delete data from
44
FULL OUTER JOINReturns all rows when there is a match in either left table or right table
45
GROUP BYGroups the result set (used with aggregate functions: COUNT, MAX, MIN, SUM, AVG)
46
HAVINGUsed instead of WHERE with aggregate functions
47
INAllows you to specify multiple values in a WHERE clause
48
INDEXCreates or deletes an index in a table
49
INNER JOINReturns rows that have matching values in both tables
50
INSERT INTOInserts new rows in a table
51
INSERT INTO SELECTCopies data from one table into another table
52
IS NULLTests for empty values
53
IS NOT NULLTests for non-empty values
54
JOINJoins tables
55
LEFT JOINReturns all rows from the left table, and the matching rows from the right table
56
LIKESearches for a specified pattern in a column
57
LIMITSpecifies the number of records to return in the result set
58
NOTOnly includes rows where a condition is not true
59
NOT NULLA constraint that enforces a column to not accept NULL values
60
ORIncludes rows where either condition is true
61
ORDER BYSorts the result set in ascending or descending order
62
OUTER JOINReturns all rows when there is a match in either left table or right table
63
PRIMARY KEYA constraint that uniquely identifies each record in a database table
64
PROCEDUREA stored procedure
65
RIGHT JOINReturns all rows from the right table, and the matching rows from the left table
66
ROWNUMSpecifies the number of records to return in the result set
67
SELECTSelects data from a database
68
SELECT DISTINCTSelects only distinct (different) values
69
SELECT INTOCopies data from one table into a new table
70
SELECT TOPSpecifies the number of records to return in the result set
71
SETSpecifies which columns and values that should be updated in a table
72
TABLECreates a table, or adds, deletes, or modifies columns in a table, or deletes a table or data inside a table
73
TOPSpecifies the number of records to return in the result set
74
TRUNCATE TABLEDeletes the data inside a table, but not the table itself
75
UNIONCombines the result set of two or more SELECT statements (only distinct values)
76
UNION ALLCombines the result set of two or more SELECT statements (allows duplicate values)
77
UNIQUEA constraint that ensures that all values in a column are unique
78
UPDATEUpdates existing rows in a table
79
VALUESSpecifies the values of an INSERT INTO statement
80
VIEWCreates, updates, or deletes a view
81
WHEREFilters a result set to include only records that fulfill a specified condition
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100