Page Comparison

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

The Customers table has a new field indicating whether the customer pays capital gains tax.

--MSSQL
ALTER TABLE CUSTOMERS ADD PAYS_CAPITAL_GAINS_TAX bit NULL;
--ORACLE VERSION
ALTER TABLE CUSTOMERS ADD PAYS_CAPITAL_GAINS_TAX NUMBER(1,0) NULL;