In the table editor, you can change table definitions.
To open the table editor for a table, choose Open in the context menu of the table in the explorer tree.
Property |
Description (Links to SQL Reference Manual) |
---|---|
Name |
|
Data Type |
|
Dim |
Dimension Maximum number of characters |
Code |
|
Key |
If you select this option, you add this column to the primary key. Key Definition (key_definition) All columns in the primary key must be NOT NULL columns. You cannot use any columns of the LOB data type in the primary key. The database ensures that no NULL value exists in the key column and that no two data records in the table have the same values in all key columns. |
Not Null |
If you select this option, the value for this column cannot be a NULL value. |
Default |
Default value |
Property |
Description (Links to SQL Reference Manual) |
---|---|
Name |
|
Definition |
Property |
Description (Link to SQL Reference Manual) |
---|---|
Name |
|
Unique |
Specifies whether the values for this columns must be unique |
Disabled |
Specifies whether the index is enabled or disabled |
Indexed Columns |
Columns that are indexed |
Usage Count |
Shows how often the system has used the index |
Bad |
Shows whether the index is damaged |
Property |
Description (Link to SQL Reference Manual) |
---|---|
Name |
Foreign key name |
Referencing Columns |
Referencing column Referential CONSTRAINT Definition (referential_constraint_definition) |
Reference Schema |
Schema to which the table with the column that is referenced belongs |
Reference Table |
Table to which the column that is referenced belongs |
Reference Column |
Column which is referenced |
Rule |
Rule for behavior of the table referenced if a data record is deleted in the referencing table |
Property |
Description (Link to SQL Reference Manual) |
---|---|
Sample Type |
Sample type that the system uses for estimating the statistics for the SQL Optimizer More information:
|
Sample Data |
Sample value (in data records or percent) that the system uses for estimating the statistics for the SQL Optimizer |
- |
Information about the current sizes (table, LOBs, and so on) and when the table was created/last changed. |
Clustered |
Only for SAP NetWeaver BI systems with BW Feature Pack This attribute has the result that the database does not distribute pages in single blocks of 8 KB across all volumes, rather, where possible it saves the contents in larger, contiguous blocks in the data volumes. More information:
|
Virtual Primary Key |
Only for SAP NetWeaver BI systems with BW Feature Pack For tables which have no primary key, the system forms a primary key internally and sets the Clustered attribute. Columns which the system uses for the primary key do not need to have the UNIQUE attribute. |
Packed |
Only for SAP NetWeaver BI systems with BW Feature Pack The system stores numerical columns that are not key columns in compressed form. |
Caching Mode |
Specifies how long data from this table is kept in the data cache, see Caching Mode. |
Property |
Description |
---|---|
Columns and Indexes |
Columns and indexes |
Different Values |
Estimated number of rows in the table If there is a big difference between the value in this column and the value in the Different Values (Exact) column, we recommend that you update the SQL optimizer statistics. For more information, see SQL Optimizer, SQL Optimizer Statistics. |
Different Values (Exact) |
Number of rows in the table (information from the internal file directory) |
Pages |
Estimated table size in pages This size affects which search strategy is selected by the system, see SQL Optimizer, Search Strategies. If there is a big difference between the value in this column and the value in the Pages (Exact) column, we recommend that you update the SQL optimizer statistics. |
Pages (Exact) |
Table size in pages (information from the internal file directory) |
Last Statistics Update |
Time of the last statistics update |