Category Name Description Example
CREATE TABLE <table-name> ( ) CREATE TABLE tableName (
id serial PRIMARY KEY,
name varchar(50) UNIQUE NOT NULL,
dateCreated timestamp DEFAULT current_timestamp
)
CREATE TABLE <table-name> as <select>
CREATE VIEW view_name AS SELECT column_name(s) FROM table_name WHERE condition
CREATE INDEX index_name ON table_name (column_name)
CREATE UNIQUE INDEX index_name ON table_name (column_name)
CREATE DATABASE database_name
CREATE PROCEDURE nameprocedure (input_parameter_name datatype, ... ) AS /* SQL code */ GO