The right pane of the Resources window displays the properties of the object selected in the tree view. The properties and their values vary depending on the selected object.
Resource Properties
The following properties appear in the properties view when a resource is selected in the tree view.
|
Property |
Description |
|---|---|
|
Resource Name |
Identifies the logical name of the data source. A resource maps a data source identifier to one or more physical databases. |
|
Database Title |
Identifies the file title of the physical database. |
Table Properties
The following properties appear in the properties view when a table is selected in the tree view.
|
Property |
Description |
|---|---|
|
Resource Name |
Identifies the logical name of the data source. A resource maps a data source identifier to one or more physical databases. |
|
Table Name |
Identifies the name of the table or view of the resource. |
|
Owner Name |
Identifies the name of the owner of the table or view. |
|
Type |
Identifies the item as a table or view. |
|
Primary Key |
Identifies the column names of the primary key for the table or view. |
Column Properties
The following properties appear in the properties view when a column is selected in the tree view.
|
Property |
Description |
|---|---|
|
Resource Name |
Identifies the logical name of the data source. A resource maps a data source identifier to one or more physical databases. |
|
Table Name |
Identifies the name of the table or view of the resource. |
|
Column Name |
Identifies the column name. |
|
Type |
Identifies the data type of the column. |
|
Length |
For a character type, identifies the number of bytes for a fixed length type and the maximum number of bytes for a variable length type. |
|
Precision |
For a fixed point number (numeric or decimal type), identifies the maximum number of digits representing the value. |
|
Scale |
For a fixed point number (numeric or decimal type), identifies the maximum number of digits representing the value to the right of the decimal point. |
|
Required |
Indicates whether the column can contain NULL values. |
Primary Key Properties
The following properties appear in the properties view when a primary key is selected in the tree view.
|
Property |
Description |
|---|---|
|
Resource Name |
Identifies the logical name of the data source. A resource maps a data source identifier to one or more physical databases. |
|
Table Name |
Identifies the name of the table or view of the resource. |
|
Column Name |
Identifies the column name. |
|
Type |
Identifies the data type of the column. |
|
Length |
For a character type, identifies the number of bytes for a fixed length type and the maximum number of bytes for a variable length type. |
|
Precision |
For a fixed point number (numeric or decimal type), identifies the maximum number of digits representing the value. |
|
Scale |
For a fixed point number (numeric or decimal type), identifies the maximum number of digits representing the value to the right of the decimal point. |
|
Required |
Indicates whether the column can contain NULL values. |
|
Primary Key Sequence |
Identifies the ordinal number for each column of that is part of the primary key. There can be more than one column that is part of the primary key. |
|
Index |
Identifies the name of the index if an index exists over this column. This property could apply to any column. |
