To Create a Table
Column specifications can be any type supported by SQL, including char, numeric, and date.
The only requirement to enable a row to be linked to an element is that one of the columns in the table be named mslink and the table has an entry (tablename and entity number) in the MSCATALOG.
For example, suppose you need to create a new table for the purpose of assessing real estate taxes. You might submit the following CREATE TABLE statement: CREATE TABLE assessor(clt_no char(30), as_val number(10),tax_rate number(10,4),mslink number(10))
The resulting table would be created (sample data is shown): Note the common column, clt_no, between the new table and the already existing parcel table.