Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table Meter (MeterID CHAR(8) CONSTRAINT MeterPK PRIMARY KEY,
- Value CHAR(8) CONSTRAINT ValueNN NOT NULL,
- InstalledDate Date CONSTRAINT InDateNN NOT NULL);
- alter table meter add ExpiryDate as (add_months(installedDate,6)) not null;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement