Home  >  Article  >  Database  >  How to view table information in navicat premium

How to view table information in navicat premium

爱喝马黛茶的安东尼
爱喝马黛茶的安东尼Original
2019-08-07 11:05:127076browse

How to view table information in navicat premium

#How to view table information in navicat premium?

We describe the fields when creating the table:

CREATE TABLE `t00_user` (
  `USER_ID` bigint(20) NOT NULL DEFAULT '0' COMMENT '主键',
  ……
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';

But when querying table information in Navicat Premium and using the function desc TABLE_NAME, the results do not include the fields. Describe the information and click "New Query" in "Query".

How to view table information in navicat premium

As shown in the figure, we want to query the field information of the t00_user table and the description information of the corresponding fields. Enter: desc t00_user in the edit box and click Run.

How to view table information in navicat premium

The running result is as shown in the figure. There is no information containing field descriptions here.

How to view table information in navicat premium

Related recommendations: "Navicat for mysql graphic tutorial"

How can we see the field information of t00_user , as shown in the figure, select "Table" under the database and double-click to open the table "Object" and find your target table t00_user.

How to view table information in navicat premium

Select your target table t00_user, right-click and find "Object Information".

How to view table information in navicat premium

In the pop-up information box, click "DDL".

How to view table information in navicat premium

You can see the detailed information when you created the table.

How to view table information in navicat premium

The above is the detailed content of How to view table information in navicat premium. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn