A profile is not valid unless you select tables and columns that are not empty, and the columns contain data types that are valid for the profile.
Some of the available profiles are meaningful only for certain data types. For example, computing a Column Pattern profile for a column that contains numeric or datetime values is not meaningful. Therefore, such a profile is not valid.
|
Profile
|
Valid Data Types*
|
|---|
|
ColumnStatisticsProfile
|
Columns of numeric type or datetime type (no mean and stddev for datetime column)
|
|
ColumnNullRatioProfile
|
All columns**
|
|
ColumnValueDistributionProfile
|
Columns of integer type, char type, and datetime type
|
|
ColumnLengthDistributionProfile
|
Columns of char type
|
|
ColumnPatternProfile
|
Columns of char type
|
|
CandidateKeyProfile
|
Columns of integer type, char type, and datetime type
|
|
FunctionalDependencyProfile
|
Columns of integer type, char type, and datetime type
|
|
InclusionProfile
|
Columns of integer type, char type, and datetime type
|
* In the previous table of valid data types, the integer, char, datetime, and numeric types include the following specific data types:
Integer types include bit, tinyint, smallint, int, and bigint.
Character types include char, nchar, varchar, and nvarchar, but do not include varchar(max) and nvarchar(max).
Date and time types include datetime, smalldatetime, and timestamp.
Numeric types include integer types (except bit), money, smallmoney, decimal, float, real, and numeric.
** image, text, xml, udt, and variant types are not supported for profiles other than the Column Null Ratio Profile.