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.

  • No labels