Databases Reference
In-Depth Information
Data Source View Properties
Each object created within the BIDS has certain properties. Within the DSV
you can view the properties of the object's DSV, tables, columns, and relation-
ships. Properties of these objects are shown in the Properties window within
the BIDS, as shown in Figure 4-17 .
Figure 4-17
Figure 4-17 shows the properties of a column in a table, calculated column, a
table, and a relationship. For the regular columns in a table you have the
properties AllowNull, Data Type, Description, Friendly Name, Length, and
Name. The properties of a column are populated by retrieving the corres-
ponding property from the data source. The data type of this column is re-
trieved from the data source. Based on the properties defined in the data
source, the properties AllowNull, Data Type, Length, Name, and Friendly
Name are populated. The length is applicable only for the data type string.
For all data types other than string the Length has a value of -1. You cannot
change certain properties. Those properties are not editable in the Properties
window and are grayed out. You can change the Friendly Name and provide
 
 
Search WWH ::




Custom Search