|
You can create, alter and drop tables and their related indexes and constraints easily using graphical wizards within Surveyor/400. In most cases, adding a field or expanding a field through Surveyor/400 runs much faster than traditional methods, since indexes often do not have to be rebuilt.
 Demonstrates the creation of a primary key for a table
Details:
 |
Access to table maintenance can be restricted by user id |
|
Create, alter and drop tables |
|
Table field attributes which can be specified include column name, data type, length, scale, nullable, default value and remarks |
|
Create Indexes for a table, including Unique, Non Unique and Encoded Vector indexes |
|
Create Primary keys, Unique keys and Foreign keys for a table |
|
Wizard can show the corresponding SQL statements (good for learning SQL or to run later as a script) |
|
When adding fields to an existing table or expanding field lengths, the existing table data, authorities and indexes are retained |
|
