SQL – ADD Keyword
March 3, 2024
The ADD keyword is used to add columns or constraints to an existing table.
SQL – ALL Keyword
March 3, 2024
The ALL keyword returns true if all of the subquery conditions are met.
SQL – ALTER Keyword
March 3, 2024
The ALTER keyword adds, deletes, or modifies columns in a table. It can also add and delete various constraints in a table.
SQL – AND Keyword
March 3, 2024
The AND keyword is used with the WHERE keyword to only include rows where both conditions is true.
SQL – ANY Keyword
March 3, 2024
The ANY keyword returns true if any of the subquery conditions are met.
SQL – AS Keyword
March 3, 2024
The AS keyword is used to output a column or table with a temporary alias for the duration of the query. Nothing in the database itself is altered.
SQL – ASC Keyword
March 3, 2024
The ASC keyword is used to sort the returned data in ascending order (A – Z).
SQL – BACKUP DATABASE Keywords
March 3, 2024
The BACKUP DATABASE keywords are used in SQL Server to create a full back up of an existing SQL database.
SQL – BETWEEN Keyword
March 3, 2024
The BETWEEN keyword is used to select values (numbers, text, or dates) within a given range (inclusively).
SQL – CASE Keyword
March 3, 2024
The CASE keyword is used is to create different output based on various conditions.
SQL – CHECK Keyword
March 3, 2024
The CHECK keyword is a constraint that limits the value that can be placed in a column.
SQL – COLUMN Keyword
March 3, 2024
The COLUMN keyword is used to change the data type of a column or delete a column in a table.
SQL – CONSTRAINT Keyword
March 3, 2024
The CONSTRAINT keyword is used to create or delete a constraint from an existing table.
SQL – CREATE Keyword
March 3, 2024
The CREATE keyword is used to create new databases, indexes, procedures, tables, and views.
SQL – DATABASE Keyword
March 3, 2024
The DATABASE keyword is used to create a new SQL database or delete an existing SQL database.
SQL – DEFAULT Keyword
March 3, 2024
The DEFAULT keyword provides a default value for a column that will be added to all new records if no other value is specified.
SQL – DELETE Keyword
March 3, 2024
The DELETE keyword is used to delete existing records in a table.
SQL – DESC Keyword
March 3, 2024
The DESC keyword is used to sort the returned data in descending order (Z – A).
SQL – DISTINCT Keyword
March 3, 2024
The DISTINCT keyword returns only different values (no two values the same) in the result set.
SQL – DROP Keyword
March 3, 2024
HTML
CSS
JavaScript
jQuery
PHP
SQL
WordPress
HTML
CSS
JavaScript
jQuery
PHP
SQL
WordPress
Why 1SMARTchicken?
This site was built and is maintained to benefit my autistic son.
See More →
See More →
Thanks for your support!
Books
All are affiliate links. Thank you for your support!
