What Are law_dba_table Table Descriptions?

The following describes the columns in law_dba_table.

Column Description

table_name

The name of the Lawson table whose storage parameters are described by the row. If a table has no value in law_dba_table, the database driver uses the default values to create and maintain the table. The TABLE_NAME column must have an uppercase value to be valid. This name must be a SQL name.
index_name The name of the index whose storage parameters are described by the value. If an index has no value in law_dba_index, the database driver program (msfdb2000) uses the default values to create and maintain the index.
fill_factor The percentage of each index page that the Microsoft SQL Server fills when creating the index.
filegroup_name The file group that the index resides in.
cluster

Whether an index is clustered or not. Allows values of Y (Yes), N (No), or Null (default).

  • N defines an index as non-clustered.

  • Y defines an index as clustered. Assigning a value of Y defines all other indexes on the same table as non-clustered because only one index can be clustered within a table.