Set WeberTrivia.com to be my default homepage.   Suggest a Question                                               

Suggest A Question : :  Frequently Asked Questions : :  Search : :  Relevant Manuals : : 
PHP Questions : :  Linux Questions : :  MySQL Questions : : 
home  [ Login ] 

32.34. table_constraints

The view table_constraints contains all constraints belonging to tables owned by the current user.

Table 32-32. table_constraints Columns

NameData TypeDescription
constraint_catalogsql_identifierName of the database that contains the constraint (always the current database)
constraint_schemasql_identifierName of the schema that contains the constraint
constraint_namesql_identifierName of the constraint
table_catalogsql_identifierName of the database that contains the table (always the current database)
table_schemasql_identifierName of the schema that contains the table
table_namesql_identifierName of the table
constraint_typecharacter_data Type of the constraint: CHECK, FOREIGN KEY, PRIMARY KEY, or UNIQUE
is_deferrablecharacter_dataYES if the constraint is deferrable, NO if not
initially_deferredcharacter_dataYES if the constraint is deferrable and initially deferred, NO if not
Who's Online
Guest Users: 9
Google
Web
WeberTrivia
WeberDev
WeberForums
 Free Sample Chapters  Free Sample Chapters
  Deliver First Class Web Sites: 101 Essential Checklists
Want to learn how to make your web sites usable and accessible? Want to ensure that your sites meet current best practice, without spending hours trawling through incomprehensible specifications and recommendations from dozens of different books, research papers, and web sites? Want to make sure that the sites you build are "right the first time," requiring no costly redevelopments?

More Sample Chapters

PHP General