Table creation/Postal addresses: Difference between revisions

Content added Content deleted
No edit summary
Line 217: Line 217:
[:zip "varchar"]))
[:zip "varchar"]))
</lang>
</lang>

=={{header|DB2 UDB}}==
<lang sql>CREATE TABLE Address (
addrID Integer generated by default as identity,
addrStreet Varchar(50) not null,
addrCity Varchar(25) not null,
addrState Char(2) not null,
addrZIP Char(10) not null
)</lang>


=={{header|EchoLisp}}==
=={{header|EchoLisp}}==
Line 1,215: Line 1,206:
);
);
</lang>
</lang>

=={{header|SQL PL}}==
{{works with|Db2 LUW}}
<lang sql>
CREATE TABLE Address (
addrID Integer generated by default as identity,
addrStreet Varchar(50) not null,
addrCity Varchar(25) not null,
addrState Char(2) not null,
addrZIP Char(10) not null
)</lang>


=={{header|Stata}}==
=={{header|Stata}}==