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.

Applies To:

DBObject Object