Table creation/Postal addresses: Difference between revisions
m
alphabetized list
(added Scheme example) |
m (alphabetized list) |
||
Line 131:
PRIMARY KEY (`addrID`)
);</lang>
=={{header|Transact-SQL}} (MSSQL)==▼
<lang sql>CREATE TABLE #Address (▼
addrID int NOT NULL Identity(1,1) PRIMARY KEY,▼
addrStreet varchar(50) NOT NULL , ▼
addrCity varchar(25) NOT NULL , ▼
addrState char(2) NOT NULL , ▼
addrZIP char(10) NOT NULL▼
)▼
drop table #Address</lang>▼
=={{header|Oracle}}==
Line 373 ⟶ 363:
)
}</lang>
▲=={{header|Transact-SQL}} (MSSQL)==
▲<lang sql>CREATE TABLE #Address (
▲ addrID int NOT NULL Identity(1,1) PRIMARY KEY,
▲ addrStreet varchar(50) NOT NULL ,
▲ addrCity varchar(25) NOT NULL ,
▲ addrState char(2) NOT NULL ,
▲ addrZIP char(10) NOT NULL
▲)
▲drop table #Address</lang>
| |||