Contact Us
 
More Info
 

Table Maintenance

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
1.800.949.4696  |  sales@linomasoftware.com  |  privacy policy
Copyright ©1994 - 2012 Linoma Software  |  All rights reserved