ADMIN_METADATA

 Show all Hide all

Deprecated.

Returns meta-data extracted using ADMIN_METADATA_EXTRACT.

Type: Table-valued function
Area of use: General use

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.
Repeat mode: 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.