SQLzoo.net

Add a column to a table

SQL Server
This is in the SQL standard ALTER TABLE The term COLUMN is optional.
Run the tidy code silently
Run set up code


Specific to SQL Server
Sybase and SQL Server do not permit the COLUMN keyword.

Related links:

  • CREATE, DROP and ALTER