Partager via


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.

Applies To: