SQL-DMO
Type Property (DBObject)
The Type property exposes configured attributes of the referenced Microsoft® SQL Server™ 2000 component.
Applies To
| DBObject Object |
Syntax
object.Type
Parts
object
Expression that evaluates to an object in the Applies To list
Data Type
Long, enumerated
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetType(SQLDMO_OBJECT_TYPE* pRetVal)
Returns
For the DBObject object, interpret the Type property using these SQLDMO_OBJECT_TYPE values.
| Constant | Value | Description |
|---|---|---|
| SQLDMOObj_AllButSystemObjects | 5119 | List or query result set membership includes all but SQL Server system objects. |
| SQLDMOObj_AllDatabaseObjects | 4607 | References Microsoft SQL Server system and user database objects. |
| SQLDMOObj_AllDatabaseUserObjects | 4605 | References only user database objects. |
| SQLDMOObj_Default | 64 | References a default. |
| SQLDMOObj_Rule | 128 | References a rule. |
| SQLDMOObj_StoredProcedure | 16 | References a stored procedure. |
| SQLDMOObj_SystemTable | 2 | References a system table. |
| SQLDMOObj_Trigger | 256 | References a trigger. |
| SQLDMOObj_UserDefinedDatatype | 4096 | References a SQL Server user-defined data type. |
| SQLDMOObj_UserDefinedFunction | 1 | References a user-defined function. |
| SQLDMOObj_UserTable | 8 | References a user-defined table. |
| SQLDMOObj_View | 4 | References a view. |