Results Set for sp_tables

Descriptions of the results reported by sp_tables.

Column

Datatype

Description

table_qualifier

varchar(30)

NULL.

table_owner

varchar(30)

Table owner.

table_name

varchar(30)

NOT NULL. The table name.

table_type

varchar(32)

NOT NULL. One of the following: 'TABLE', 'VIEW', 'SYSTEM TABLE'.

remarks

varchar(254)

NULL