Advertisement
Guest User

Untitled

a guest
Jul 24th, 2014
189
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. create table Meter (MeterID CHAR(8) CONSTRAINT MeterPK PRIMARY KEY,
  2. Value CHAR(8) CONSTRAINT ValueNN NOT NULL,
  3. InstalledDate Date CONSTRAINT InDateNN NOT NULL);
  4.  
  5. alter table meter add ExpiryDate as (add_months(installedDate,6)) not null;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement