ADMIN_METADATA

Show allHide all

Deprecated. Don't use for new development and try to migrate existing uses.

Type: Table-valued function

Returns meta-data extracted using ADMIN_METADATA_EXTRACT.

Parameters

@resultsetid mandatory uniqueidentifier
The resultsetid returned from ADMIN_METADATA_EXTRACT.

Resultsets

Resultset: Meta-data

Returns rows for each column in the resultset. If multiple tables are returned by the sql query all columns from all tables will appear in this resultset.
Table count: repeated exactly once
Row count: zero or more rows

Columns

columnname mandatory string
The name of the column.
columnorder mandatory int
The zero-based ordinal of the column within the table.
datatype mandatory string
The name of the datatype of the column.
isidentity mandatory bit
Indicates if the column is an identity column.
isnullable mandatory bit
The nullability of the column.
isprimarykey mandatory bit
Indicates if the column is the primary key of the table.
maxlength mandatory string
The maximum length of the column or NULL if not applicable.
tableorder mandatory int
The zero-based ordinal of the table.