Table creation/Postal addresses: Difference between revisions

addrZIP Char(10) not null

)</lang>

 

=={{header|J}}==

J is a programming language, not a database, but it ships with a database built in the programming language called [[j:JDB|JDB]]. Using that, assuming <tt>hd</tt> is your database, then:

 

addrID autoid;

addrStreet varchar

addrState char

addrZip char

 

Of course J can connect external databases too, using e.g. [[j:Studio/ODBC%20Basics|ODBC]]. See the [[j:DB|list of J database topics]].

 

=={{header|SAS}}==

LENGTH addrID 8. street 50$ city 25$ state 2$ zip 20$;

STOP;

 

=={{header|Tcl}}+{{header|SQLite}}==