Shulou(Shulou.com)06/01 Report--

This article mainly introduces the method of navicat premium to view the table information, the article is very detailed, has a certain reference value, interested friends must read it!

How does navicat premium view table information?

We describe the fields when we create the table:

CREATE TABLE `t00user` (`USER_ ID` bigint (20) NOT NULL DEFAULT'0' COMMENT 'primary key', …) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=' user Table'

But in Navicat Premium query table information, use the function desc TABLE_NAME, the result does not contain field description information, click "query" in the "New query".

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

The running result is shown in the figure, and there is no information that contains the description of the field here.

How can we see the t00_user field information, as shown in the figure, select the "table" under the database and double-click, you can 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 message box, click "DDL".

You can see the details when you created the table.

The above is all the contents of this article "how to view table information in navicat premium". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.