Table creation/Postal addresses: Difference between revisions
Content added Content deleted
No edit summary |
|||
Line 1,199: | Line 1,199: | ||
<lang sql> |
<lang sql> |
||
CREATE TABLE Address ( |
CREATE TABLE Address ( |
||
addrID |
addrID Integer generated by default as identity, |
||
addrStreet |
addrStreet Varchar(50) not null, |
||
addrCity |
addrCity Varchar(25) not null, |
||
addrState |
addrState Char(2) not null, |
||
addrZIP |
addrZIP Char(10) not null |
||
)</lang> |
)</lang> |
||