Jump to content

Table creation/Postal addresses: Difference between revisions

no edit summary
No edit summary
Line 217:
[:zip "varchar"]))
</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}}==
Line 1,215 ⟶ 1,206:
);
</lang>
 
=={{header|DB2SQL UDBPL}}==
{{works with|Db2 LUW}}
<lang sql>
<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}}==
Anonymous user
Cookies help us deliver our services. By using our services, you agree to our use of cookies.