Javatpoint Logo
Javatpoint Logo

SQLite Syntax

Syntax is a unique set of rules and guidelines. Following is a list of syntax for SQLite.

Case sensitivity:

  • SQLite is not case sensitive. But, there are some commands which are case sensitive.
  • For example: GLOB and glob have different meaning in SQLite statements.

Comments:

  • Comments are used to add more readability in your SQLite code.
  • Comments cannot be nested.
  • Comments begin with two consecutive "-" characters.
  • Sometimes it also appears with "/*" and extend up to and including the next "*/" character pair.

SQLite Statements

All the SQLite statement is started with any of the keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, etc. All the statement will end with a semicolon (;).

SQLite ANALYZE Statement

Syntax:

SQLite AND/OR Clause

Syntax:

SQLite ALTER TABLE Statement

Syntax:

SQLite ALTER TABLE Statement (Rename)

Syntax:

SQLite ATTACH DATABASE Statement

Syntax:

SQLite BEGIN TRANSACTION Statement

Syntax:

SQLite BETWEEN Clause

Syntax:

SQLite CREATE INDEX Statement

Syntax:

SQLite CREATE UNIQUE INDEX Statement

Syntax:

SQLite CREATE TABLE Statement

Syntax:

SQLite CREATE TRIGGER Statement

Syntax:

SQLite CREATE VIEW Statement

Syntax:

SQLite CREATE VIRTUAL TABLE Statement

Syntax:

SQLite COMMIT TRANSACTION Statement

Syntax:

SQLite COUNT Clause

Syntax:

SQLite DELETE Statement

Syntax:

SQLite DETACH DATABASE Statement

Syntax:

SQLite DISTINCT Clause

Syntax:

SQLite DROP INDEX Statement

Syntax:

SQLite DROP TABLE Statement

Syntax:

SQLite DROP VIEW Statement

Syntax:

SQLite DROP TRIGGER Statement

Syntax:

SQLite EXISTS Clause

Syntax:

SQLite EXPLAIN Statement

Syntax:

SQLite GLOB Clause

Syntax:

SQLite GROUP BY Clause

Syntax:

SQLite HAVING Clause

Syntax:

SQLite INSERT INTO Statement

Syntax:

SQLite IN Clause

Syntax:

SQLite Like Clause

Syntax:

SQLite NOT IN Clause

Syntax:

SQLite ORDER BY Clause

Syntax:

SQLite PRAGMA Statement

Syntax:

For example:

SQLite RELEASE SAVEPOINT Statement

Syntax:

SQLite REINDEX Statement

Syntax:

SQLite ROLLBACK Statement

Syntax:

SQLite SAVEPOINT Statement

Syntax:

SQLite SELECT Statement

Syntax:

SQLite UPDATE Statement

Syntax:

SQLite VACUUM Statement

Syntax:


Next TopicSQLite Data Types




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


B.Tech / MCA