Type Property (DBObject)
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The Type property exposes configured attributes of the referenced Microsoft SQL Server component.
Sintaxis
object
.Type
Parts
- object
An 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 except SQL Server system objects. |
SQLDMOObj_/AllDatabaseObjects |
4607 |
References 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. |