sqlcmd.net validated sql reference

Tag archive

#alter

Commands grouped around the same concept, pattern, or recurring problem.

5 commands with this tag Browse related patterns quickly
beginner defining MySQL MariaDB SQL Server PostgreSQL SQLite

Add A Column To An Existing Table

Extend a table's structure by adding a new column with `ALTER TABLE`.

intermediate ddl MySQL MariaDB SQL Server PostgreSQL SQLite

Add a Foreign Key Constraint

Enforce referential integrity by linking a column to the primary key of another table so orphaned rows cannot be inserted.

intermediate ddl MySQL MariaDB SQL Server PostgreSQL

Change a Column's Data Type With ALTER TABLE

Modify the data type, default value, or nullability of an existing column without recreating the table.

intermediate defining MySQL MariaDB SQL Server PostgreSQL SQLite

Remove A Column From A Table With ALTER TABLE DROP COLUMN

Permanently delete a column and all its data from a table using ALTER TABLE.

beginner ddl MySQL MariaDB SQL Server PostgreSQL SQLite

Rename a Column With ALTER TABLE

Change a column's name in place without dropping or recreating the table or its data.