Tutorials
Altering Tables

Let's add a column to the Antiques table to allow the entry of the price of a given Item:

ALTER TABLE ANTIQUES ADD (PRICE DECIMAL(8,2) NULL);

The data for this new column can be updated or inserted as shown later.

SQL
Database Indexes
Create Table
SQL Select
SQL Alias
SQL Insert
SQL Update
SQL Delete
SQL Alter
SQL group by & having
SQL Subqueries
SQL Exists, All & Any
SQL Joins
SQL Aggregate Functions
SQL Drop
SQL Union & All
Constraints
Create Views
SQL Transactions