Table Properties

Table Object Properties Methods Lists Collections

Property Description

Application
    Application
    Write: No
The Application object.
Attributes
    SQLOLE_TABLEATT_TYPE
    Write: No
The attributes of this table.
ClusteredIndex
    Index
    Write: No
The clustered Index object.
CreateDate
    String
    Write: No
The date and time this table was created.
DataSpaceUsed
    Long
    Write: No
Storage space in kilobytes used by the rows of this table.
ID
    Long
    Write: No
The object ID of the table.
IndexSpaceUsed
    Long
    Write: No
Storage space in kilobytes used by the indexes on this table.
Name
    Identifier
    Write: Yes
The name of the table.
Owner
    Identifier
    Write: No
The user who created the table.
Parent
    Database
    Write: No
The Database object.
PrimaryKey
    Key
    Write: No
The primary Key object for this table.
Rows
    Long
    Write: No
The number of rows currently in this table.
SystemObject
    
    Write:
Indicates if this is a SQL Server system table. If True, this is a SQL Server system table. If False, this table was created by a user.
TypeOf
    SQLOLE_OBJECT_TYPE
    Write: No
The type of object.
UserData
    Long
    Write: Yes
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property.