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".

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.

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

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.

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

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

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

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!