Table creation/Postal addresses: Difference between revisions
Content added Content deleted
| Line 1,198: | Line 1,198: | ||
{{works with|Db2 LUW}} |
{{works with|Db2 LUW}} |
||
<lang sql> |
<lang sql> |
||
CREATE TABLE Address ( |
|||
addrID Integer generated by default as identity, |
addrID Integer generated by default as identity, |
||
addrStreet Varchar(50) not null, |
addrStreet Varchar(50) not null, |
||
| Line 1,204: | Line 1,204: | ||
addrState Char(2) not null, |
addrState Char(2) not null, |
||
addrZIP Char(10) not null |
addrZIP Char(10) not null |
||
); |
|||
</lang> |
|||
=={{header|SQLite}}== |
=={{header|SQLite}}== |
||