![]() In the top right corner of the query results page, there is a button to export the function, click to select a variety of export formats, as shown inĪt this point, the data dictionary is exported quickly. Select Table_schema,table_name,column_type,column_comment frominformation_lumns where TABLE_SCHEMA= ' Guifan ' or table_schema= ' test ' `COLUMN_COMMENT` varchar(1024) NOT NULLDEFAULT ‘‘įor example, I need to export the data dictionary information for the Guifan library and the test library: on data warehouse tables to ensure our departments data dictionary remains accurate. `PRIVILEGES` varchar(80) NOT NULL DEFAULT ‘‘, Navicat Premium is a multi-connection database development and. ![]() `COLUMN_KEY` varchar(3) NOT NULL DEFAULT ‘‘, `COLLATION_NAME` varchar(32) DEFAULT NULL, `CHARACTER_SET_NAME` varchar(32) DEFAULTNULL, Navicat Data Modeler Supreme Database Modeling and Design Tool Feature Matrix Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. `DATETIME_PRECISION` bigint(21) unsignedDEFAULT NULL, `NUMERIC_SCALE` bigint(21) unsigned DEFAULTNULL, `NUMERIC_PRECISION` bigint(21) unsignedDEFAULT NULL, ![]() `CHARACTER_OCTET_LENGTH` bigint(21) unsignedDEFAULT NULL, `CHARACTER_MAXIMUM_LENGTH` bigint(21)unsigned DEFAULT NULL, `DATA_TYPE` varchar(64) NOT NULL DEFAULT ‘‘, `IS_NULLABLE` varchar(3) NOT NULL DEFAULT ‘‘, `ORDINAL_POSITION` bigint(21) unsigned NOTNULL DEFAULT ‘0‘, `COLUMN_NAME` varchar(64) NOT NULL DEFAULT‘‘, `TABLE_NAME` varchar(64) NOT NULL DEFAULT ‘‘, `TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT‘‘, Our client is looking for a Junior Data Modeler to join their exceptional team.This is a permanentSee this and similar jobs on LinkedIn. `TABLE_CATALOG` varchar(512) NOT NULL DEFAULT‘‘, Using the columns table in MySQL's information_schemaĪnd the export function in Navicat for fast Export data dictionary ĭata dictionary is a DBA need to maintain the important content, some people like to use Excel to maintain, I prefer to directly in the production library maintenance, so that the production library to ensure that the comments are the latest content, in order to facilitate the flow of production library data dictionary, will be used in Excel to record the way, This article records how to quickly export data dictionary information from a production library to Excel. Otherwise, the legal liability will be investigated. Original works, allow reprint, please be sure to use hyperlinks in the form of the original source of the article, author information and this statement.
0 Comments
Leave a Reply. |