Home > Database > navicat > body text

How to view table information in navicat

angryTom
Release: 2019-08-08 10:23:56
Original
19108 people have browsed it

How to view table information in navicat

There is a very fast way to view table information in navicat, which is to use the DDL method to quickly view the information of the entire table. Let’s introduce it to you in detail.

Recommended tutorial: MySQL database video tutorial

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

How to view table information in navicat

2. The running result is as shown in the figure. There are no fields included here. The description information

How to view table information in navicat

3. 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", find your target table t00_user

How to view table information in navicat

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

How to view table information in navicat

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

How to view table information in navicat

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

How to view table information in navicat

Extended information

 

Navicat is a set of fast, reliable and affordable database management tools , designed to simplify database management and reduce system management costs. It is designed to meet the needs of database administrators, developers and small and medium-sized enterprises. Navicat is built with an intuitive graphical user interface that allows you to create, organize, access and share information in a secure and easy way.

Navicat is world-famous and widely trusted by major enterprises, government agencies, and educational institutions around the world. It is also an essential daily working partner for practitioners from all walks of life. Since 2001, Navicat has been downloaded over 2,000,000 times worldwide and has a customer base of over 70,000 users. More than 100 Fortune 500 companies are using Navicat.

Navicat provides up to 7 languages ​​for customers to choose from and is recognized as the most popular database front-end user interface tool in the world.

 It can be used to manage and develop local or remote MySQL, SQL Server, SQLite, Oracle and PostgreSQL databases.

Navicat is powerful enough to meet all the needs of professional developers, and is easy to learn for those new to database servers. With a comprehensive graphical user interface (GUI), Navicat lets you create, organize, access and share information in a secure and simple way.

Navicat is available on three platforms - Microsoft Windows, Mac OS X and Linux. It allows users to connect to any local or remote server, and provides some practical database tools such as data model, data transfer, data synchronization, structure synchronization, import, export, backup, restore, report creation tools and plans to assist in managing data.

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

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!