Type Property (DBObject)
Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.
The Type property exposes configured attributes of the referenced Microsoft SQL Server component.
Syntaxe
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. |