Index Object
Collections
Property |
Type |
Version |
Description |
---|---|---|---|
Fields |
Fields |
3.0/3.5 |
Collection of fields in the Index object |
Properties |
Properties |
3.0/3.5 |
Collection of Property objects |
Methods
Method |
Parameters |
Returns |
Version |
Description |
---|---|---|---|---|
CreateField |
[Name], [Type], [Size] |
Field |
3.0/3.5 |
Creates a new Field object |
CreateProperty |
[Name], [Type], [Value], [DDL] |
Property |
3.0/3.5 |
Creates a new user-defined Property object |
Properties
Property |
Type |
Version |
Description |
---|---|---|---|
Clustered |
Boolean |
3.0/3.5 |
Indicates whether the index is clustered |
DistinctCount |
Long |
3.0/3.5 |
Number of unique values in this Index object |
Foreign |
Boolean |
3.0/3.5 |
Indicates whether an Index object represents a foreign key |
IgnoreNulls |
Boolean |
3.0/3.5 |
Indicates whether Null values are stored in the index |
Name |
String |
3.0/3.5 |
Name of this Index object |
Primary |
Boolean |
3.0/3.5 |
Indicates whether this is a primary index |
Required |
Boolean |
3.0/3.5 |
Indicates whether the index requires a non-Null value |
Unique |
Boolean |
3.0/3.5 |
Indicates whether this is a unique index for a table |
Get Access Database Design and Programming, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.