SQL rules

Declaring

Lowercase identifiers

SQL identifiers should be lowercase.

Before

CREATE TABLE Users (
  Id INT PRIMARY KEY,
  Name VARCHAR(255) NOT NULL
);

After

CREATE TABLE users (
  id INT PRIMARY KEY,
  name VARCHAR(255) NOT NULL
);

Lowercase functions

SQL functions should be lowercase.

Before

SELECT COUNT(*)
  FROM users
  WHERE active = TRUE;

After

SELECT count(*)
  FROM users
  WHERE active = TRUE;

Uppercase keywords

SQL keywords should be uppercase.

Before

select *
  from users
  where id = 1;

After

SELECT *
  FROM users
  WHERE id = 1;

Uppercase literals

SQL literals should be uppercase.

Before

SELECT *
  FROM users
  WHERE active = true;

After

SELECT *
  FROM users
  WHERE active = TRUE;

Uppercase types

SQL types should be uppercase.

Before

CREATE TABLE users (
  id int PRIMARY KEY,
  name varchar(255) NOT NULL
);

After

CREATE TABLE users (
  id INT PRIMARY KEY,
  name VARCHAR(255) NOT NULL
);