Anonymous user
Table creation/Postal addresses: Difference between revisions
no edit summary
No edit summary |
No edit summary |
||
Line 1,194:
var exec = db.prepare(statment);
exec.execute;</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|SQLite}}==
Line 1,206 ⟶ 1,217:
);
</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}}==
| |||