显示表命令的约束
我有一些表，我尝试在其上设置 PK FK 关系，但我想验证这一点.如何显示 PK/FK 约束?我看到了 this 手册页，但确实如此不显示示例，我的谷歌搜索也没有结果.我的数据库是 credentialing1，我的约束表是 <code>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.).
相关文章