SQL

Structured Query Language (SQL) is a domain-specific language used to manage data, especially in a relational database management system (RDBMS).

• Create Database

  • Syntax: CREATE DATABASE <DATABASE_NAME>;
  • eg. CREATE DATABASE category;

• Create Table

  • Syntax: CREATE TABLE <TABLE_NAME> (<COLUMN_INFO>);
  • eg. CREATE TABLE IF NOT EXISTS account (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, account_name TEXT);

• Delete Table

  • Syntax: DROP TABLE <TABLE_NAME> ;
  • eg. DROP TABLE IF EXISTS entry;