Information storage

The following options modify the database configuration:

• Column Name

• Column Data Types

• Unique (Constraint)

• Identity or Primary Key Column (Constraint)

When the table configuration is read from the database, the existing table definition is cleared, and the assigned attribute and visibility information for matching column names is preserved (that is, if a column name in the table definition matches a column name being read from the database, the assigned attribute and visibility information is retained).

The SQLData object can modify the data table without data loss. However, changing a data type will result in loss of precision (this is a function of SQL Server).