Movatterモバイル変換

table_catalogsql_identifier

Name of the database that contains the table (always the current database)

table_schemasql_identifier

Name of the schema that contains the table

table_namesql_identifier

Name of the table

table_typecharacter_data

Type of the table:BASE TABLE for a persistent base table (the normal table type),VIEW for a view,FOREIGN for a foreign table, orLOCAL TEMPORARY for a temporary table

self_referencing_column_namesql_identifier

Applies to a feature not available inPostgreSQL

reference_generationcharacter_data

Applies to a feature not available inPostgreSQL

user_defined_type_catalogsql_identifier

If the table is a typed table, the name of the database that contains the underlying data type (always the current database), else null.

user_defined_type_schemasql_identifier

If the table is a typed table, the name of the schema that contains the underlying data type, else null.

user_defined_type_namesql_identifier

If the table is a typed table, the name of the underlying data type, else null.

is_insertable_intoyes_or_no

YES if the table is insertable into,NO if not (Base tables are always insertable into, views not necessarily.)

is_typedyes_or_no

YES if the table is a typed table,NO if not

commit_actioncharacter_data

Not yet implemented