|
Column name
|
Column number
|
Data type
|
Description
|
|---|---|---|---|
|
TABLE_CAT
|
1
|
NVARCHAR not Null
|
Catalog name
|
|
TABLE_SCHEM
|
2
|
NVARCHAR
|
Schema name; null if
not applicable to the data source. If a driver supports schemas for
some tables but not for others, such as when the driver retrieves
data from different DBMSs, it returns an empty string ("")
for those tables that do not have schemas.
|
|
TABLE_NAME
|
3
|
NVARCHAR not null
|
Table name
|
|
TABLE_TYPE
|
4
|
NVARCHAR not null
|
Table type name; one
of the following: TABLE, VIEW, SYSTEM TABLE, GLOBAL TEMPORARY, LOCAL
TEMPORARY, ALIAS, SYNONYM, or a data source-specific type name. The
meanings of ALIAS and SYNONYM are driver-specific.
|
|
REMARKS
|
5
|
NVARCHAR
|
A description of the
table
|
|
NATIVE_CAT
|
6
|
NVARCHAR
|
The native data store's
Catalog; null if not applicable to the data source. If a driver supports
catalogs for some tables but not for others, such as when the driver
retrieves data from different DBMSs, it returns an empty string ("")
for those tables that do not have catalogs.
|
|
SECURITY
|
7
|
NVARCHAR
|
The security environment
the view executes under. Valid values are “DEFINER”,
“INVOKER”, or null. A value of “DEFINER”
indicates the view executes under the rights of the owner of the schema
containing the view.
A value of “INVOKER” indicates the view executes under
the rights of the invoker. Null is returned if the security environment
is unknown or the view is a native view.
|
|
SERVICE
|
8
|
NVARCHAR
|
The
service responsible for managing the view. Valid values are “FEDSQL”,
“DRIVER”, or null. A value of “FEDSQL”
indicates the view is managed via a FEDSQL connection to the appropriate
driver. A value of “DRIVER” (or a null value) indicates
a native view managed by a DBMS driver.
|