Movatterモバイル変換

ホーム

36.48. `table_constraints`
Prev	Up	Chapter 36. The Information Schema	Home	Next

36.48. `table_constraints`

The viewtable_constraints contains all constraints belonging to tables that the current user owns or has some privilege other thanSELECT on.

Table 36.46. table_constraints Columns

Column Type Description
`constraint_catalogsql_identifier` Name of the database that contains the constraint (always the current database)
`constraint_schemasql_identifier` Name of the schema that contains the constraint
`constraint_namesql_identifier` Name of the constraint
`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
`constraint_typecharacter_data` Type of the constraint:`CHECK`,`FOREIGN KEY`,`PRIMARY KEY`, or`UNIQUE`
`is_deferrableyes_or_no` `YES` if the constraint is deferrable,`NO` if not
`initially_deferredyes_or_no` `YES` if the constraint is deferrable and initially deferred,`NO` if not
`enforcedyes_or_no` Applies to a feature not available inPostgreSQL (currently always`YES`)

Column Type

Description

constraint_catalogsql_identifier

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

constraint_schemasql_identifier

Name of the schema that contains the constraint

constraint_namesql_identifier

Name of the constraint

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

constraint_typecharacter_data

Type of the constraint:CHECK,FOREIGN KEY,PRIMARY KEY, orUNIQUE

is_deferrableyes_or_no

YES if the constraint is deferrable,NO if not

initially_deferredyes_or_no

YES if the constraint is deferrable and initially deferred,NO if not

enforcedyes_or_no

Applies to a feature not available inPostgreSQL (currently alwaysYES)

Prev	Up	Next
36.47. `sql_sizing`	Home	36.49. `table_privileges`

By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

ページ先頭