{"id":155,"date":"2018-12-06T09:42:40","date_gmt":"2018-12-06T09:42:40","guid":{"rendered":"https:\/\/barkhane.com\/sql\/2018\/12\/06\/sql-keywords\/"},"modified":"2024-03-03T18:01:53","modified_gmt":"2024-03-03T18:01:53","slug":"sql-keywords","status":"publish","type":"post","link":"https:\/\/barkhane.com\/sql\/sql-keywords\/","title":{"rendered":"SQL Keywords"},"content":{"rendered":"

This SQL keywords reference contains the reserved words in SQL.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Keyword<\/strong><\/th>\nDescription<\/th>\n<\/tr>\n
ADD<\/strong><\/td>\nAdds a column in an existing table<\/td>\n<\/tr>\n
ADD CONSTRAINT<\/strong><\/td>\nAdds a constraint after a table is already created<\/td>\n<\/tr>\n
ALTER<\/strong><\/td>\nAdds, deletes, or modifies columns in a table, or changes the data type of a column in a table<\/td>\n<\/tr>\n
ALTER COLUMN<\/strong><\/td>\nChanges the data type of a column in a table<\/td>\n<\/tr>\n
ALTER TABLE<\/strong><\/td>\nAdds, deletes, or modifies columns in a table<\/td>\n<\/tr>\n
ALL<\/strong><\/td>\nReturns true if all of the subquery values meet the condition<\/td>\n<\/tr>\n
AND<\/strong><\/td>\nOnly includes rows where both conditions is true<\/td>\n<\/tr>\n
ANY<\/strong><\/td>\nReturns true if any of the subquery values meet the condition<\/td>\n<\/tr>\n
AS<\/strong><\/td>\nRenames a column or table with an alias<\/td>\n<\/tr>\n
ASC<\/strong><\/td>\nSorts the result set in ascending order<\/td>\n<\/tr>\n
BACKUP DATABASE<\/strong><\/td>\nCreates a back up of an existing database<\/td>\n<\/tr>\n
BETWEEN<\/strong><\/td>\nSelects values within a given range<\/td>\n<\/tr>\n
CASE<\/strong><\/td>\nCreates different outputs based on conditions<\/td>\n<\/tr>\n
CHECK<\/strong><\/td>\nA constraint that limits the value that can be placed in a column<\/td>\n<\/tr>\n
COLUMN<\/strong><\/td>\nChanges the data type of a column or deletes a column in a table<\/td>\n<\/tr>\n
CONSTRAINT<\/strong><\/td>\nAdds or deletes a constraint<\/td>\n<\/tr>\n
CREATE<\/strong><\/td>\nCreates a database, index, view, table, or procedure<\/td>\n<\/tr>\n
CREATE DATABASE<\/strong><\/td>\nCreates a new SQL database<\/td>\n<\/tr>\n
CREATE INDEX<\/strong><\/td>\nCreates an index on a table (allows duplicate values)<\/td>\n<\/tr>\n
CREATE OR REPLACE VIEW<\/strong><\/td>\nUpdates a view<\/td>\n<\/tr>\n
CREATE TABLE<\/strong><\/td>\nCreates a new table in the database<\/td>\n<\/tr>\n
CREATE PROCEDURE<\/strong><\/td>\nCreates a stored procedure<\/td>\n<\/tr>\n
CREATE UNIQUE INDEX<\/strong><\/td>\nCreates a unique index on a table (no duplicate values)<\/td>\n<\/tr>\n
CREATE VIEW<\/strong><\/td>\nCreates a view based on the result set of a SELECT statement<\/td>\n<\/tr>\n
DATABASE<\/strong><\/td>\nCreates or deletes an SQL database<\/td>\n<\/tr>\n
DEFAULT<\/strong><\/td>\nA constraint that provides a default value for a column<\/td>\n<\/tr>\n
DELETE<\/strong><\/td>\nDeletes rows from a table<\/td>\n<\/tr>\n
DESC<\/strong><\/td>\nSorts the result set in descending order<\/td>\n<\/tr>\n
DISTINCT<\/strong><\/td>\nSelects only distinct (different) values<\/td>\n<\/tr>\n
DROP<\/strong><\/td>\nDeletes a column, constraint, database, index, table, or view<\/td>\n<\/tr>\n
DROP COLUMN<\/strong><\/td>\nDeletes a column in a table<\/td>\n<\/tr>\n
DROP CONSTRAINT<\/strong><\/td>\nDeletes a UNIQUE, PRIMARY KEY, FOREIGN KEY, or CHECK constraint<\/td>\n<\/tr>\n
DROP DATABASE<\/strong><\/td>\nDeletes an existing SQL database<\/td>\n<\/tr>\n
DROP DEFAULT<\/strong><\/td>\nDeletes a DEFAULT constraint<\/td>\n<\/tr>\n
DROP INDEX<\/strong><\/td>\nDeletes an index in a table<\/td>\n<\/tr>\n
DROP TABLE<\/strong><\/td>\nDeletes an existing table in the database<\/td>\n<\/tr>\n
DROP VIEW<\/strong><\/td>\nDeletes a view<\/td>\n<\/tr>\n
EXEC<\/strong><\/td>\nExecutes a stored procedure<\/td>\n<\/tr>\n
EXISTS<\/strong><\/td>\nTests for the existence of any record in a subquery<\/td>\n<\/tr>\n
FOREIGN KEY<\/strong><\/td>\nA constraint that is a key used to link two tables together<\/td>\n<\/tr>\n
FROM<\/strong><\/td>\nSpecifies which table to select or delete data from<\/td>\n<\/tr>\n
FULL OUTER JOIN<\/strong><\/td>\nReturns all rows when there is a match in either left table or right table<\/td>\n<\/tr>\n
GROUP BY<\/strong><\/td>\nGroups the result set (used with aggregate functions: COUNT, MAX, MIN, SUM, AVG)<\/td>\n<\/tr>\n
HAVING<\/strong><\/td>\nUsed instead of WHERE with aggregate functions<\/td>\n<\/tr>\n
IN<\/strong><\/td>\nAllows you to specify multiple values in a WHERE clause<\/td>\n<\/tr>\n
INDEX<\/strong><\/td>\nCreates or deletes an index in a table<\/td>\n<\/tr>\n
INNER JOIN<\/strong><\/td>\nReturns rows that have matching values in both tables<\/td>\n<\/tr>\n
INSERT INTO<\/strong><\/td>\nInserts new rows in a table<\/td>\n<\/tr>\n
INSERT INTO SELECT<\/strong><\/td>\nCopies data from one table into another table<\/td>\n<\/tr>\n
IS NULL<\/strong><\/td>\nTests for empty values<\/td>\n<\/tr>\n
IS NOT NULL<\/strong><\/td>\nTests for non-empty values<\/td>\n<\/tr>\n
JOIN<\/strong><\/td>\nJoins tables<\/td>\n<\/tr>\n
LEFT JOIN<\/strong><\/td>\nReturns all rows from the left table, and the matching rows from the right table<\/td>\n<\/tr>\n
LIKE<\/strong><\/td>\nSearches for a specified pattern in a column<\/td>\n<\/tr>\n
LIMIT<\/strong><\/td>\nSpecifies the number of records to return in the result set<\/td>\n<\/tr>\n
NOT<\/strong><\/td>\nOnly includes rows where a condition is not true<\/td>\n<\/tr>\n
NOT NULL<\/strong><\/td>\nA constraint that enforces a column to not accept NULL values<\/td>\n<\/tr>\n
OR<\/strong><\/td>\nIncludes rows where either condition is true<\/td>\n<\/tr>\n
ORDER BY<\/strong><\/td>\nSorts the result set in ascending or descending order<\/td>\n<\/tr>\n
OUTER JOIN<\/strong><\/td>\nReturns all rows when there is a match in either left table or right table<\/td>\n<\/tr>\n
PRIMARY KEY<\/strong><\/td>\nA constraint that uniquely identifies each record in a database table<\/td>\n<\/tr>\n
PROCEDURE<\/strong><\/td>\nA stored procedure<\/td>\n<\/tr>\n
RIGHT JOIN<\/strong><\/td>\nReturns all rows from the right table, and the matching rows from the left table<\/td>\n<\/tr>\n
ROWNUM<\/strong><\/td>\nSpecifies the number of records to return in the result set<\/td>\n<\/tr>\n
SELECT<\/strong><\/td>\nSelects data from a database<\/td>\n<\/tr>\n
SELECT DISTINCT<\/strong><\/td>\nSelects only distinct (different) values<\/td>\n<\/tr>\n
SELECT INTO<\/strong><\/td>\nCopies data from one table into a new table<\/td>\n<\/tr>\n
SELECT TOP<\/strong><\/td>\nSpecifies the number of records to return in the result set<\/td>\n<\/tr>\n
SET<\/strong><\/td>\nSpecifies which columns and values that should be updated in a table<\/td>\n<\/tr>\n
TABLE<\/strong><\/td>\nCreates a table, or adds, deletes, or modifies columns in a table, or deletes a table or data inside a table<\/td>\n<\/tr>\n
TOP<\/strong><\/td>\nSpecifies the number of records to return in the result set<\/td>\n<\/tr>\n
TRUNCATE TABLE<\/strong><\/td>\nDeletes the data inside a table, but not the table itself<\/td>\n<\/tr>\n
UNION<\/strong><\/td>\nCombines the result set of two or more SELECT statements (only distinct values)<\/td>\n<\/tr>\n
UNION ALL<\/strong><\/td>\nCombines the result set of two or more SELECT statements (allows duplicate values)<\/td>\n<\/tr>\n
UNIQUE<\/strong><\/td>\nA constraint that ensures that all values in a column are unique<\/td>\n<\/tr>\n
UPDATE<\/strong><\/td>\nUpdates existing rows in a table<\/td>\n<\/tr>\n
VALUES<\/strong><\/td>\nSpecifies the values of an INSERT INTO statement<\/td>\n<\/tr>\n
VIEW<\/strong><\/td>\nCreates, updates, or deletes a view<\/td>\n<\/tr>\n
WHERE<\/strong><\/td>\nFilters a result set to include only records that fulfill a specified condition<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

This SQL keywords reference contains the reserved words in SQL. Keyword Description ADD Adds a column in an existing table […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[2],"tags":[],"class_list":["post-155","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/posts\/155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/comments?post=155"}],"version-history":[{"count":0,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/posts\/155\/revisions"}],"wp:attachment":[{"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/media?parent=155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/categories?post=155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/barkhane.com\/sql\/wp-json\/wp\/v2\/tags?post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}