```

The [!INCLUDE[ssDE](../../includes/ssde-md.md)] assumes that *object_id* is in the current database context. A query that references an *object_id* in another database will return NULL or incorrect results. For example, in the following query the current database context is the master database. The [!INCLUDE[ssDE](../../includes/ssde-md.md)] will try to return the property value for the specified *object_id* in that database instead of the database that is specified in the query. The query returns incorrect results because the view `vEmployee` is not in the master database.

USE master;

GO

SELECT OBJECTPROPERTYEX(OBJECT_ID(N'AdventureWorks2012.HumanResources.vEmployee'), 'IsView');

The following example creates a SYNONYM `MyEmployeeTable` for the `Employee` table in the [!INCLUDE[ssSampleDBobject](../../includes/sssampledbobject-md.md)] database and then returns the base type of the SYNONYM.

USE AdventureWorks2012;

GO

CREATE SYNONYM MyEmployeeTable FOR HumanResources.Employee;

The following example returns the number of UPDATE triggers on the specified table.

USE AdventureWorks2012;

GO

SELECT OBJECTPROPERTYEX(OBJECT_ID(N'HumanResources.Employee'), N'TABLEUPDATETRIGGERCOUNT');

GO

```

The following example uses the `TableHasForeignKey` property to return all the tables that have a FOREIGN KEY constraint.

USE AdventureWorks2012;

GO

SELECT name, object_id, schema_id, type_desc

FROM sys.objects

WHERE OBJECTPROPERTYEX(object_id, N'TableHasForeignKey') = 1

ORDER BY name;

GO

```

The following example returns the base type of `dbo.DimReseller` object.

SELECT OBJECTPROPERTYEX ( object_id(N'dbo.DimReseller'), N'BaseType')AS BaseType;