Data model metadata (types and columns)
operators #tsql#operators
Description
OBJECT_ID
Returns the ID for a schema-scoped object.
OBJECT_NAME
Returns the object name for an object ID.
OBJECT_SCHEMA_NAME
Returns the schema name of an object.
SCHEMA_ID
Returns a schema’s ID.
SCHEMA_NAME
Returns a schema’s name by ID.
PARSENAME
Returns a part of a multipart object name (server, database, schema, object).
@@PROCID
Returns the ID of the currently executing stored procedure.
Inspect what an object is, how it behaves, and how it’s implemented. This inspection includes
the definition and properties, and CLR assembly metadata.
Description
OBJECT_DEFINITION
Returns the definition (source text) of programmable objects.
OBJECTPROPERTY
Returns a property for an object (for example, whether it’s a view, table, and so
on).
OBJECTPROPERTYEX
Returns extended object property information.
ASSEMBLYPROPERTY
Returns a specified property value of a SQL CLR assembly.
Understand type identity and properties, and column identity and properties. Use this
metadata for schema validation, code generation, ETL, and compatibility checks.
Description
TYPE_ID
Returns the ID of a data type.
Expand table
Expand table
Expand table