INFORMATION_SCHEMA.TABLES

This view contains the following information on each user-defined or publicly created table:

Column Heading Definition
table_catalog Database containing the table
table_schema    Schema (owner) of the table; the owner can be either the current schema (user) viewing the INFORMATION_SCHEMA or the PUBLIC schema
table_name Name of the table
table_type Type of table — the possible values are:
  • T — User
  • V — View