The ExtendedPropertyNames type exposes the following members.
Constructors
Name | Description | |
---|---|---|
ExtendedPropertyNames | Initializes a new instance of the ExtendedPropertyNames class |
Methods
Name | Description | |
---|---|---|
Equals | (Inherited from Object.) | |
Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) | |
GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) | |
GetType | Gets the Type of the current instance. (Inherited from Object.) | |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) | |
ToString | Returns a string that represents the current object. (Inherited from Object.) |
Fields
Name | Description | |
---|---|---|
CascadeDelete | ||
CascadeUpdate | ||
Collation |
The collation setting
| |
Comment |
A comment.
| |
ComputedDefinition |
The statement that defines the computed field
| |
ConstraintDefinitionFormat | ||
ConstraintNameFormat | ||
ConstraintTypeFormat | ||
DatabaseMajorVersion |
Major Version.
| |
DatabaseVersion |
Version.
| |
DefaultValue |
The default value
| |
Description |
The Description
| |
DRIIndex |
The index is used to maintain a declarative referential constraint.
Click here for more information. | |
DRIPrimaryKey |
The index implements a SQL Server PRIMARY KEY constraint. A value is returned only.
Click here for more information. | |
DRIUniqueKey |
The index implements a UNIQUE constraint on a table not constrained by primary key. The index is a candidate key.
Click here for more information. | |
DropExist |
Optimizes index creation when an existing index is rebuilt.
Click here for more information. | |
FileGroup |
The FileGroup property identifies the file group used to store Microsoft SQL Server table or index data.
Click here for more information. | |
IdentityIncrement |
Identity Increment
| |
IdentitySeed |
Identity Seed
| |
IgnoreDuplicateKey |
Controls error generation when an INSERT or UPDATE operation could cause a constraint violation and the index implements a PRIMARY KEY or UNIQUE constraint.
Click here for more information. | |
IsAggregateFunction |
Scalar Function.
| |
IsAutoStatistics |
The StatisticsIndex property directs Index object property evaluation when the object is used to create a Microsoft SQL Server index.
Click here for more information. | |
IsCLR |
CLR Procedure or Function.
| |
IsClustered |
The index is clustered. SQL Server supports a single clustered index on any table.
Click here for more information. | |
IsComputed |
Computed Column or Index
| |
IsConstraint | ||
IsDescending | ||
IsDeterministic |
Column is Deterministic.
True if Deterministic (results are consistent).
False if Indeterminate (results might differ with a given set of input values).
| |
IsFullTextKey |
The IsFullTextKey property identifies the index used by Microsoft Search to support row identification.
Click here for more information. | |
IsHypothetical |
Redirects index creation, mapping Index object manipulation to CREATE STATISTICS and DROP STATISTICS statements.
Click here for more information. | |
IsIdentity |
Identity Column
| |
IsInlineTableValuedFunction |
Inline-Table-Valued Function.
| |
IsMultiStatementTableValuedFunction |
Multi-Statement-Table-Valued Function
| |
IsNotForReplication | ||
IsRowGuidColumn |
The Column is a Row Guid
| |
IsScalarFunction |
Scalar Function.
| |
IsSchemaAlias |
Returns true if the Schema Object is aliased.
Some relational database management systems (RDBMS) like DB2 support aliasing of schema objects.
Click here for more information. | |
IsStatistics |
The StatisticsIndex property directs Index object property evaluation when the object is used to create a Microsoft SQL Server index.
Click here for more information. | |
IsTableIndex | ||
IsTableValuedFunction |
Table-Valued Function
| |
IsTrigger | ||
IsUserDefinedTableType |
User Defined Table Type.
| |
NoRecompute |
Creates index with statistics computation off.
Click here for more information. | |
NumberOfResultSets |
Number of result sets that a command can return.
Click here for more information. | |
ObjectID | ||
ObjectType |
The object type of a Schema Object.
| |
OriginalFillFactor |
The FillFactor property exposes the percent of each page used to store index data when the index is created.
Click here for more information. | |
PadIndex |
Index nodes are padded using a fill factor.
Click here for more information. | |
ParameterID | ||
Sequence | ||
SourceSchemaName |
If the schema is aliased, then the Extended Property value should contain Schema Object name that is aliased.
Some relational database management systems (RDBMS) like DB2 support aliasing of schema objects.
Click here for more information. | |
SourceSchemaOwner |
If the schema is aliased, then the Extended Property value should contain Schema Object owner that is aliased.
Some relational database management systems (RDBMS) like DB2 support aliasing of schema objects.
Click here for more information. | |
SpecificName |
Use a specific name to declare an identifier for a UDR that is unique in the database or name space. Use the Specific Name segment whenever you see a reference to a specific name in a syntax diagram.
Click here for more information.Click here for more information. | |
SystemType |
The System Type (E.G., System.String)
| |
UserDefinedType | ||
WithNoCheck |