INFORMATION_SCHEMA.COLUMNS

Returns a list of all tables and columns in the current InMemory database.

Table_Catalog

Name of the tables catalog (targitdb - static)

Table_Schema

Name of the tables schema (dbo - static)

Table_Name

Name of the table

Column_Name

Name of the column

Ordinal_Position

Position of column within table

Data_Type

Type of data


Example:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.