显示表上的约束命令

问题描述

我有一些表格，我尝试在其上设置 PK FK 关系，但我想验证这一点.如何显示 PK/FK 限制?我看到了 this 手册页，但确实如此没有显示示例，我的谷歌搜索也没有结果.我的数据库是 credentialing1，我的约束表是 practices 和 cred_insurances.

I have tables that I've tried setting PK FK relationships on but I want to verify this. How can I show the PK/FK restraints? I saw this manual page, but it does not show examples and my google search was fruitless also. My database is credentialing1 and my constrained tables are practices and cred_insurances.

推荐答案

我用

SHOW CREATE TABLE mytable;

这向您展示了以当前形式重新创建 mytable 所需的 SQL 语句.您可以看到所有列及其类型(如 DESC)，但它还显示约束信息(以及表类型、字符集等).

This shows you the SQL statement necessary to receate mytable in its current form. You can see all the columns and their types (like DESC) but it also shows you constraint information (and table type, charset, etc.).

这篇关于显示表上的约束命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！