Databases Reference
In-Depth Information
PID
String
3
.0/3.5
P
ersonal identifier (PID) for the group or user account
A.11 Index Object
A.11.1 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
A.11.2 Methods
Method
Parameters
R
eturns
V
ersion
Description
CreateField
[
Name], [Type], [Size]
F
ield
3
.0/3.5
Creates a new Field object
CreateProperty
[Name], [Type], [Value],
[
DDL]
Creates a new user-defined Property
object
Property 3.0/3.5
A.11.3 Properties
Property
Type
Version
Description
Clustered
Boolean
3.0/3.5
Indicates whether the index is clustered
DistinctCount
L
ong
3
.0/3.5
N
umber of unique values in this Index object
Foreign
Boolean
3.0/3.5
Indicates whether an Index object represents a foreign key
IgnoreNulls
B
oolean
3
.0/3.5
I
ndicates whether Null values are stored in the index
Name
String
3.0/3.5
Name of this Index object
Primary
B
oolean
3
.0/3.5
I
ndicates whether this is a primary index
Required
Boolean
3.0/3.5
Indicates whether the index requires a non-Null value
Unique
B
oolean
3
.0/3.5
I
ndicates whether this is a unique index for a table
A.12 Parameter Object
A.12.1 Properties
Property Type
Version
Description
Direction Integer
3.5
I
ndicates whether a Parameter is for input, output, or returned values
Name
String
3.0/3.5
N
ame of this Parameter object
Type
Integer
3.0/3.5
D
ata type of the object
Value
Variant 3.0/3.5
T
he object's value
A.13 Property Object
A.13.1 Properties
Property
Type
Version
Description