Tag archive
Commands grouped around the same concept, pattern, or recurring problem.
Extend a table's structure by adding a new column with `ALTER TABLE`.
Save a `SELECT` statement as a named view so it can be queried like a table.
Define a new table with column names and data types using `CREATE TABLE`.
Permanently remove a table and all its data with `DROP TABLE`.
Inspect a table definition to see its column names and data types.
Inspect the current database or schema to see which tables exist.
Create an index on one or more columns to make lookups and joins faster.