Skip to content
  • Blog (1)
  • About Us
  • Tags
  • Donations
1SMARTchicken - Code Made Easy
  • Tutorials (176)
  • Reference (2172)
  • Snippets (69)

Category: SQL Keywords

1SMARTchicken - Code Made Easy

Category: SQL Keywords

  • Tutorials (176)
  • Reference (2172)
  • Snippets (69)
  • Blog (1)
  • About Us
  • Tags
  • Donations
1SMARTchicken - Code Made Easy
  • Tutorials (176)
  • Reference (2172)
  • Snippets (69)
1SMARTchicken - Code Made Easy

Category: SQL Keywords

  • Tutorials (176)
  • Reference (2172)
  • Snippets (69)
  • Home
  • Reference
  • SQL Reference
  • SQL Keywords
SQL Reference

SQL – ADD Keyword

August 8, 2024 / Reference, SQL Keywords, SQL Reference / Keyword

The ADD keyword is used to add columns or constraints to an existing table.

SQL Reference

SQL – ALL Keyword

August 9, 2024 / Reference, SQL Keywords, SQL Reference / Keyword

The ALL keyword returns true if all of the subquery conditions are met.

SQL Reference

SQL – ALTER Keyword

August 9, 2024 / Reference, SQL Keywords, SQL Reference / Keyword

The ALTER keyword adds, deletes, or modifies columns in a table. It can also add and delete various constraints in a table.

SQL Reference

SQL – AND Keyword

August 9, 2024 / Reference, SQL Keywords, SQL Reference / Keyword

The AND keyword is used with the WHERE keyword to only include rows where both conditions is true.

SQL Reference

SQL – ANY Keyword

August 9, 2024 / Reference, SQL Keywords, SQL Reference / Keyword

The ANY keyword returns true if any of the subquery conditions are met.

SQL Reference

SQL – AS Keyword

August 9, 2024 / Reference, SQL Keywords, SQL Reference / Keyword

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 Reference

SQL – ASC Keyword

August 9, 2024 / Reference, SQL Keywords, SQL Reference / Keyword

The ASC keyword is used to sort the returned data in ascending order (A – Z).

SQL Reference

SQL – BACKUP DATABASE Keywords

August 9, 2024 / Reference, SQL Keywords, SQL Reference / Keyword, SQL Server

The BACKUP DATABASE keywords are used in SQL Server to create a full back up of an existing SQL database.

SQL Reference

SQL – BETWEEN Keyword

August 9, 2024 / Reference, SQL Keywords, SQL Reference / Keyword

The BETWEEN keyword is used to select values (numbers, text, or dates) within a given range (inclusively).

SQL Reference

SQL – CASE Keyword

August 9, 2024 / Reference, SQL Keywords, SQL Reference / Conditional, Keyword

The CASE keyword is used is to create different output based on various conditions.

SQL Reference

SQL – CHECK Keyword

August 9, 2024 / Reference, SQL Keywords, SQL Reference / Keyword, MySQL, SQL Server

The CHECK keyword is a constraint that limits the value that can be placed in a column.

SQL Reference

SQL – COLUMN Keyword

August 10, 2024 / Reference, SQL Keywords, SQL Reference / Keyword

The COLUMN keyword is used to change the data type of a column or delete a column in a table.

SQL Reference

SQL – CONSTRAINT Keyword

August 10, 2024 / Reference, SQL Keywords, SQL Reference / Keyword, MySQL, SQL Server

The CONSTRAINT keyword is used to create or delete a constraint from an existing table.

SQL Reference

SQL – CREATE Keyword

August 10, 2024 / Reference, SQL Keywords, SQL Reference / Keyword

The CREATE keyword is used to create new databases, indexes, procedures, tables, and views.

SQL Reference

SQL – DATABASE Keyword

August 10, 2024 / Reference, SQL Keywords, SQL Reference / Keyword

The DATABASE keyword is used to create a new SQL database or delete an existing SQL database.

SQL Reference

SQL – DEFAULT Keyword

August 10, 2024 / Reference, SQL Keywords, SQL Reference / Keyword, MySQL, SQL Server

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 Reference

SQL – DELETE Keyword

August 10, 2024 / Reference, SQL Keywords, SQL Reference / Keyword

The DELETE keyword is used to delete existing records in a table.

SQL Reference

SQL – DESC Keyword

August 10, 2024 / Reference, SQL Keywords, SQL Reference / Keyword

The DESC keyword is used to sort the returned data in descending order (Z – A).

SQL Reference

SQL – DISTINCT Keyword

August 10, 2024 / Reference, SQL Keywords, SQL Reference / Keyword

The DISTINCT keyword returns only different values (no two values the same) in the result set.

SQL Reference

SQL – DROP Keyword

August 10, 2024 / Reference, SQL Keywords, SQL Reference / Keyword, MySQL, SQL Server

The DROP keyword is used to delete existing columns, constraints, databases, indexes, tables, and views.

1 2 3 Next →

or View All Tags

Tutorials

  • HTML Tutorials (40)
  • CSS Tutorials (45)
    • CSS Flexbox (12)
  • JavaScript Tutorials (6)
  • jQuery Tutorials (13)
  • PHP Tutorials (0)
  • SQL Tutorials (0)
  • Python Tutorials (72)
    • Python File Handling (4)
    • Python and MySQL (4)
  • WordPress Tutorials (0)

Reference

  • HTML Reference (244)
    • HTML Tags (107)
    • HTML Attributes (46)
    • HTML Events (76)
    • HTML Resources (15)
  • CSS Reference (309)
    • CSS Selectors (55)
    • CSS Properties (220)
    • CSS Functions (17)
    • CSS Resources (17)
  • JavaScript Reference (555)
    • JavaScript Selectors (7)
    • JavaScript Operators (12)
    • JavaScript Statements (17)
    • JavaScript Methods (284)
    • JavaScript Properties (162)
    • JavaScript RegExp (45)
    • JavaScript Resources (28)
  • jQuery Reference (220)
    • jQuery Selectors (54)
    • jQuery Methods (140)
    • jQuery Ajax Methods (16)
    • jQuery Properties (17)
    • jQuery Resources (9)
  • PHP Reference (460)
    • PHP Keywords (59)
    • PHP Functions (400)
    • PHP Constants (0)
    • PHP Resources (1)
  • SQL Reference (290)
    • SQL Keywords (59)
    • MySQL Functions (138)
    • SQL Server Functions (83)
    • SQL Resources (10)
  • Python Reference (94)
    • Python Methods (86)
    • Python Resources (8)
  • WordPress Reference (0)

Snippets

  • HTML Snippets (3)
  • CSS Snippets (12)
  • JavaScript Snippets (5)
  • jQuery Snippets (8)
  • PHP Snippets (1)
  • SQL Snippets (3)
  • Python Snippets (1)
  • WordPress Snippets (36)
1SMARTchicken - Code Made Easy

333 Washington Blvd.
Suite 126
Marina del Rey, CA 90292
United States

contact2025@1smartchicken.com

  • About Us
  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Search for Code:

or View All Tags

Copyright © 2025 1SMARTchicken | All Rights Reserved.