Type Property (DBObject)
В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.
The Type property exposes configured attributes of the referenced Microsoft SQL Server component.
Синтаксис
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. |