This view has a row for every constraint in every table in the database, except for NULL constraints. Those are presented as the column IS_NULLABLE at SHOW COLUMNS view.The output is ordered by the table_name column.Data can be filtered with IN TABLE table_name syntax.The following table lists the output’s columns:
Column name
Data type
Description
TABLE_NAME
VARCHAR(127)
The table name. This is the filter column.
COLUMN_NAME
VARCHAR(127)
The column the constraint is set on
CONSTRAINT_TYPE
CHAR(1)
f = foreign key constraint, p = primary key constraint, u = unique constraint
REF_TABLE_NAME
VARCHAR(127)
For foreign key constraint: The referenced table the foreign key is pointing to. Otherwise null.
REF_COL_NAME
VARCHAR(127)
For foreign key constraint: The column in the reference table the foreign key is referring to. Otherwise null.
Was this page helpful?
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Regatta","colors":{"primary":"#ff6600","light":"#FF6600","dark":"#ff6600"},"logo":{"light":"https://mintcdn.com/regatta/HR4-Kyi3p6WFSWx7/logo/Regatta_Logo_Colors_Black_RGB_1.svg?fit=max\u0026auto=format\u0026n=HR4-Kyi3p6WFSWx7\u0026q=85\u0026s=80ecf4af831aaabfecd51ca1c1dab7a7","dark":"https://mintcdn.com/regatta/HR4-Kyi3p6WFSWx7/logo/Regatta_Logo_Colors_White_RGB_1.svg?fit=max\u0026auto=format\u0026n=HR4-Kyi3p6WFSWx7\u0026q=85\u0026s=1be4bc683939b389d14aa1eeda3216d9"},"favicon":"https://mintcdn.com/regatta/xrn8wIqTNfsgHe4O/images/favicon.svg?fit=max\u0026auto=format\u0026n=xrn8wIqTNfsgHe4O\u0026q=85\u0026s=c025dcbef503c87e965049f809c4a3c4","background":{"color":{"light":"#f7f8fa","dark":"#041225"}},"navbar":{"links":[{"href":"https://rdbproject.atlassian.net/servicedesk/customer/portals","label":"Support"}],"primary":{"type":"button","label":"Start Coding","href":"https://regatta.dev/"}},"footer":{"socials":{"x":"https://twitter.com/regatta_data","linkedin":"https://www.linkedin.com/company/regatta-data"}},"fonts":{"family":"Inter"},"styling":{"latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"regatta","hasAudioNarration":false,"actualSubdomain":"regatta","customDomains":["docs.regatta.dev"],"gitSource":{"type":"github","owner":"regattadata","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"feedback":{"thumbs":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"REMOVE_BRANDING":{"status":"ENABLED"},"CONTEXTUAL_FEEDBACK":{"status":"ENABLED"},"CODE_SNIPPET_FEEDBACK":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6af9b9685a8e334304f95aa9","clientVersion":"0.0.4143","searchFilterCounts":[{"language":"default","tag":"SQL","count":84},{"language":"default","tag":"Self-Hosted Deployment","count":38},{"language":"default","tag":"Tuning Performance","count":20},{"language":"default","tag":"Regatta Deployment Tool","count":19},{"language":"default","tag":"Quickstart","count":18},{"language":"default","tag":"System Monitoring","count":18},{"language":"default","tag":"Drivers \u0026 Clients","count":16},{"language":"default","tag":"SQL Functions and Operators","count":15},{"language":"default","tag":"Kubernetes Deployment","count":13},{"language":"default","tag":"Hints","count":12}]},"assistantConfig":{},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":"body::-webkit-scrollbar{width:5px}body::-webkit-scrollbar-thumb{background-color:#888;border-radius:10px}body::-webkit-scrollbar-track{background-color:#f1f1f1}#sidebar-content::-webkit-scrollbar{display:none}table td:first-child,table th:first-child{max-width:16rem}table code{white-space:normal;overflow-wrap:break-word;word-break:break-word}"}],"page":{"pagePath":"sql/system-monitoring/database-catalog/show-constraints","slug":"/sql/system-monitoring/database-catalog/show-constraints","pageMetadata":{"title":"SHOW CONSTRAINTS","description":null,"href":"/sql/system-monitoring/database-catalog/show-constraints"},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={code:`code`,p:`p`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,..._provideComponents(),...props.components},{Table}=_components;if(!Table)_missingMdxReference(`Table`,true);return _jsxs(_Fragment,{children:[_jsxs(_components.p,{children:[`This view has a row for every constraint in every table in the database, except for `,_jsx(_components.code,{children:`NULL`}),` constraints. Those are presented as the column `,_jsx(_components.code,{children:`IS_NULLABLE`}),` at `,_jsx(_components.code,{children:`SHOW COLUMNS`}),` view.`]}),`\n`,_jsxs(_components.p,{children:[`The output is ordered by the `,_jsx(_components.code,{children:`table_name`}),` column.`]}),`\n`,_jsxs(_components.p,{children:[`Data can be filtered with `,_jsx(_components.code,{children:`IN TABLE`}),` table_name syntax.`]}),`\n`,_jsx(_components.p,{children:`The following table lists the output’s columns:`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{style:{textAlign:`left`},children:`Column name`}),_jsx(_components.th,{style:{textAlign:`left`},children:`Data type`}),_jsx(_components.th,{style:{textAlign:`left`},children:`Description`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:`TABLE_NAME`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`VARCHAR(127)`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`The table name. This is the filter column.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:`COLUMN_NAME`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`VARCHAR(127)`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`The column the constraint is set on`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:`CONSTRAINT_TYPE`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`CHAR(1)`})}),_jsxs(_components.td,{style:{textAlign:`left`},children:[_jsx(_components.code,{children:`f`}),` = foreign key constraint, `,_jsx(_components.code,{children:`p`}),` = primary key constraint, `,_jsx(_components.code,{children:`u`}),` = unique constraint`]})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:`REF_TABLE_NAME`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`VARCHAR(127)`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`For foreign key constraint: The referenced table the foreign key is pointing to. Otherwise null.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{style:{textAlign:`left`},children:`REF_COL_NAME`}),_jsx(_components.td,{style:{textAlign:`left`},children:_jsx(_components.code,{children:`VARCHAR(127)`})}),_jsx(_components.td,{style:{textAlign:`left`},children:`For foreign key constraint: The column in the reference table the foreign key is referring to. Otherwise null.`})]})]})]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"SHOW CONSTRAINTS","description":null,"href":"/sql/system-monitoring/database-catalog/show-constraints"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":[],"subdomain":"regatta","siteName":"Regatta","title":"SHOW CONSTRAINTS - Regatta","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-11-08T11:26:32.247Z","originalFileLocation":"sql/system-monitoring/database-catalog/show-constraints.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"application-name\" content=\"Regatta\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"SHOW CONSTRAINTS - Regatta\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Regatta\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-constraints\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://regatta.mintlify.site/_mintlify/api/og/v2?division=Database+Catalog+Data\u0026amp;title=SHOW+CONSTRAINTS\u0026amp;theme=acca279d31253fc5f4f921a2\u0026amp;signature=89bb9d9479a72847ecff3d32d5ba522ffa7824eea7e53e46c4f29195d87af991\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"SHOW CONSTRAINTS - Regatta\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://regatta.mintlify.site/_mintlify/api/og/v2?division=Database+Catalog+Data\u0026amp;title=SHOW+CONSTRAINTS\u0026amp;theme=acca279d31253fc5f4f921a2\u0026amp;signature=89bb9d9479a72847ecff3d32d5ba522ffa7824eea7e53e46c4f29195d87af991\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Regatta\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#ff6600\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-constraints\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/sql/system-monitoring/database-catalog/show-constraints.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.regatta.dev/#organization\",\"name\":\"Regatta\",\"url\":\"https://docs.regatta.dev\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/regatta/HR4-Kyi3p6WFSWx7/logo/Regatta_Logo_Colors_Black_RGB_1.svg?fit=max\u0026auto=format\u0026n=HR4-Kyi3p6WFSWx7\u0026q=85\u0026s=80ecf4af831aaabfecd51ca1c1dab7a7\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.regatta.dev#website\",\"name\":\"Regatta\",\"url\":\"https://docs.regatta.dev\",\"publisher\":{\"@id\":\"https://docs.regatta.dev/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-constraints#webpage\",\"url\":\"https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-constraints\",\"name\":\"SHOW CONSTRAINTS\",\"dateModified\":\"2026-11-08T11:26:32.247Z\",\"isPartOf\":{\"@id\":\"https://docs.regatta.dev#website\"},\"breadcrumb\":{\"@id\":\"https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-constraints#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-constraints#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"System Monitoring\",\"item\":\"https://docs.regatta.dev/sql/system-monitoring/system-monitoring-views/system-monitoring-views\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Catalog Data\",\"item\":\"https://docs.regatta.dev/sql/system-monitoring/database-catalog/database-catalog\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SHOW CONSTRAINTS\",\"item\":\"https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-constraints\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-constraints#article\",\"headline\":\"SHOW CONSTRAINTS\",\"name\":\"SHOW CONSTRAINTS\",\"url\":\"https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-constraints\",\"mainEntityOfPage\":{\"@id\":\"https://docs.regatta.dev/sql/system-monitoring/database-catalog/show-constraints#webpage\"},\"dateModified\":\"2026-11-08T11:26:32.247Z\",\"publisher\":{\"@id\":\"https://docs.regatta.dev/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.regatta.dev#website\"}}]}\u003c/script>","agentPointerHref":"/sql/system-monitoring/database-catalog/show-constraints.md","siteName":"Regatta","nav":{"global":null,"anchors":[{"anchor":"Docs Home","icon":"house","pages":[{"title":"Docs Home","href":"/home"}]},{"anchor":"Quickstart","pages":[{"title":"Quickstart","href":"/getting-started/getting-started-using-regatta-cloud"}]},{"anchor":"SQL","icon":"code","groups":[{"group":"SQL Specification","pages":[{"title":"Introduction","href":"/sql/introduction"}]},{"group":"SQL Syntax Conventions","pages":[{"title":"SQL Syntax Conventions","href":"/sql/sql-syntax-convention"}]},{"group":"Data Types","pages":[{"title":"Introduction","href":"/sql/data-types/introduction"},{"group":"Numeric types","pages":[{"title":"Exact numeric data type","href":"/sql/data-types/numeric-types/exact-numeric-data-type"},{"title":"Approximate numeric data type","href":"/sql/data-types/numeric-types/approximate-numeric-data-type"}]},{"title":"Character types","href":"/sql/data-types/character-types"},{"title":"Date/Time types","href":"/sql/data-types/date-time-types"},{"title":"Boolean types","href":"/sql/data-types/boolean-types"},{"title":"UUID type","href":"/sql/data-types/uuid-type"},{"group":"Type Conversion","pages":[{"title":"Type Conversion","href":"/sql/data-types/type-conversion/type-conversion"},{"title":"Type conversion table","href":"/sql/data-types/type-conversion/type-conversion-table"}]},{"title":"ROW IDs","href":"/sql/data-types/row-ids"}]},{"group":"SQL Functions and Operators","pages":[{"title":"SQL Functions and Operators","href":"/sql/sql-functions-and-operators/sql-functions-and-operators"},{"title":"Comparison Functions and Operators","href":"/sql/sql-functions-and-operators/comparison-function"},{"group":"Mathematical Functions and Operators","pages":[{"title":"Mathematical Functions and Operators","href":"/sql/sql-functions-and-operators/maths-functions-operators/maths-functions-operators"},{"title":"Mathematical Operators","href":"/sql/sql-functions-and-operators/maths-functions-operators/maths-operators"},{"title":"Mathematical Functions","href":"/sql/sql-functions-and-operators/maths-functions-operators/maths-functions"}]},{"title":"String Functions and Operators","href":"/sql/sql-functions-and-operators/string-functions-operators"},{"title":"Date/Time Functions and Operators","href":"/sql/sql-functions-and-operators/date-time-functions-operators/date-time-functions-operators"},{"group":"Conditional Expressions","pages":[{"title":"CASE","href":"/sql/sql-functions-and-operators/conditional-expressions/case"}]},{"group":"Convert Functions","pages":[{"title":"CAST","href":"/sql/sql-functions-and-operators/convert-function/cast"},{"title":"Date and Time Formatting Functions","href":"/sql/sql-functions-and-operators/convert-function/date-time-format-functions"}]},{"group":"Aggregate Functions","pages":[{"title":"Aggregate Functions","href":"/sql/sql-functions-and-operators/aggregate-functions/aggregate-functions"},{"title":"Examples","href":"/sql/sql-functions-and-operators/aggregate-functions/examples"}]},{"group":"Subquery Expressions","pages":[{"title":"Subquery Expressions","href":"/sql/sql-functions-and-operators/subquery-expressions/subquery-expressions"},{"title":"IN and NOT IN","href":"/sql/sql-functions-and-operators/subquery-expressions/not-in/not-in"}]},{"title":"UUID Functions and Operators","href":"/sql/sql-functions-and-operators/untitled-page"}]},{"group":"Data Definition Language (DDL) Commands","pages":[{"title":"CREATE TABLE","href":"/sql/ddl-commands/create-table"},{"title":"ALTER TABLE","href":"/sql/ddl-commands/alter-table"},{"title":"DROP TABLE","href":"/sql/ddl-commands/drop-table"}]},{"group":"Data Manipulation Language Commands","pages":[{"title":"INSERT","href":"/sql/dml-commands/insert"},{"title":"UPDATE","href":"/sql/dml-commands/update"},{"title":"DELETE","href":"/sql/dml-commands/delete"}]},{"group":"Transaction Control Language Commands","pages":[{"title":"Transaction Control Language Commands","href":"/sql/tcl-commands/tcl-commands"},{"title":"SET TRANSACTION","href":"/sql/tcl-commands/set-transaction"}]},{"group":"Data Query Language","pages":[{"title":"SELECT","href":"/sql/dql/select"},{"title":"EXPLAIN","href":"/sql/dql/explain"}]},{"group":"Hints","pages":[{"title":"Overview","href":"/sql/hints/overview"},{"title":"General notes","href":"/sql/hints/general-notes"},{"group":"Join hints","pages":[{"title":"Join hints","href":"/sql/hints/join-hints/join-hints"},{"title":"Hint - Join direction","href":"/sql/hints/join-hints/join-direction"},{"title":"Hint - Join method","href":"/sql/hints/join-hints/join-method"},{"title":"Hint - Join distribution method","href":"/sql/hints/join-hints/join-distribution"}]},{"group":"Hints for parallelism of distributed operations","pages":[{"title":"Hint for parallelism of distributed operations","href":"/sql/hints/parallelism/hints-for-parallelism"},{"title":"Hint - Distributed Sorting","href":"/sql/hints/parallelism/sorting"},{"title":"Hint - Join distribution","href":"/sql/hints/parallelism/join-distribution"}]},{"group":"Other hints","pages":[{"title":"Other hints","href":"/sql/hints/other-hints/other-hints"},{"title":"Hint - INDEX","href":"/sql/hints/other-hints/hint-index"},{"title":"Hint - Cardinality","href":"/sql/hints/other-hints/hint-cardinality"}]}]},{"group":"Managing Users","pages":[{"title":"CREATE USER","href":"/sql/managing-users/create-user"},{"title":"ALTER USER","href":"/sql/managing-users/alter-user"},{"title":"DROP USER","href":"/sql/managing-users/drop-user"}]},{"group":"System Monitoring","pages":[{"title":"Using System Monitoring Views","href":"/sql/system-monitoring/system-monitoring-views/system-monitoring-views"},{"title":"SHOW SYSTEM VIEWS","href":"/sql/system-monitoring/show-system-views"},{"group":"Database Catalog Data","pages":[{"title":"Database Catalog Data","href":"/sql/system-monitoring/database-catalog/database-catalog"},{"title":"SHOW TABLES","href":"/sql/system-monitoring/database-catalog/show-tables"},{"title":"SHOW TABLE DEVICES","href":"/sql/system-monitoring/database-catalog/show-table-devices"},{"title":"SHOW INDEXES","href":"/sql/system-monitoring/database-catalog/show-index"},{"title":"SHOW INDEX DEVICES","href":"/sql/system-monitoring/database-catalog/show-index-devices"},{"title":"SHOW COLUMNS","description":null,"href":"/sql/system-monitoring/database-catalog/show-columns"},{"title":"SHOW CONSTRAINTS","href":"/sql/system-monitoring/database-catalog/show-constraints"},{"title":"SHOW USERS","description":null,"href":"/sql/system-monitoring/database-catalog/show-users"}]},{"group":"System Catalog Data","pages":[{"title":"SHOW NODES","href":"/sql/system-monitoring/system-catalog/show-nodes"},{"title":"SHOW MODULES","href":"/sql/system-monitoring/system-catalog/show-modules"},{"title":"SHOW DEVICES","href":"/sql/system-monitoring/system-catalog/show-devices"}]},{"group":"Dynamic System Data","pages":[{"title":"Dynamic System Data","href":"/sql/system-monitoring/dynamic-system/dynamic-system"},{"title":"SHOW METRIC DESCRIPTION","href":"/sql/system-monitoring/dynamic-system/show-metric-description"},{"title":"SHOW DATABASE METRICS","href":"/sql/system-monitoring/dynamic-system/show-database-metric"},{"title":"SHOW MODULE METRICS","href":"/sql/system-monitoring/dynamic-system/show-module-metrics"},{"title":"SHOW DEVICE METRICS","href":"/sql/system-monitoring/dynamic-system/show-device-metrics"}]}]},{"group":"System Management","pages":[{"title":"System States and Commands","href":"/sql/system-management/system-states-and-commands"},{"title":"Nodes","href":"/sql/system-management/nodes"},{"title":"Modules","href":"/sql/system-management/modules"},{"title":"Storage Devices","href":"/sql/system-management/storage-devices"},{"title":"System Manager","href":"/sql/system-management/system-manager"}]},{"group":"Appendices","pages":[{"title":"Identifiers Limitations","href":"/sql/appendices/indentifiers-limitations"},{"title":"Database Limitations","href":"/sql/appendices/database-limitations"},{"title":"Reserved Words","href":"/sql/appendices/reserved-words"}]},{"group":"Vector Index","pages":[{"title":"Introduction","href":"/sql/vector-index/introduction"},{"group":"DDL","pages":[{"title":"Creating a Vector Index","href":"/sql/vector-index/ddl/creating-vector-index"},{"title":"Deleting a Vector Index","href":"/sql/vector-index/ddl/deleting-vector-index"},{"title":"Modifying a Vector Index","href":"/sql/vector-index/ddl/modifying-vector-index"}]},{"title":"Show Commands","href":"/sql/vector-index/show-commands"},{"title":"Performing Approximate Vector Searches","href":"/sql/vector-index/performing-approximate-vector-searches"}]}]},{"anchor":"Regatta Cloud","icon":"cloud","pages":[{"title":"Regatta Cloud","href":"/regatta-cloud/regatta-cloud/regatta-cloud"}]},{"anchor":"Self-Hosted Deployment","icon":"server","pages":[{"title":"Self-Hosted Deployment","href":"/self-hosted-deployment/prerequisites"}]},{"anchor":"Drivers \u0026 Clients","icon":"download","pages":[{"title":"Drivers \u0026 Clients","href":"/drivers-and-clients/connecting-applications-to-regatta"}]},{"anchor":"Tuning Performance","icon":"rocket","pages":[{"title":"Tuning Performance","href":"/tuning-performance/introduction/introduction"}]}]},"basePath":"","title":"SHOW CONSTRAINTS - Regatta","buildId":"dpl_Fyv1NbzwP68g2bEH2Roy98uY1zmE","deploymentId":"dpl_Fyv1NbzwP68g2bEH2Roy98uY1zmE","dynamics":[],"chunks":[]}