OBJECTPROPERTY - information about schema-scoped objects in SQL Server

OBJECTPROPERTY (ObjectId, PropertyName)

Returns information about schema-scoped objects in the current database.

See the properties list in:

http://msdn.microsoft.com/en-us/library/ms176105.aspx

See the schema-scoped objects list in:

http://msdn.microsoft.com/en-us/library/ms190324.aspx

Examples:

SELECT OBJECTPROPERTY(OBJECT_ID, N'IsIndexed')

SELECT OBJECTPROPERTY(object_id, N'SchemaId')