![]() ![]() 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: `PRIVILEGES` varchar(80) NOT NULL DEFAULT ‘‘, `COLUMN_KEY` varchar(3) NOT NULL DEFAULT ‘‘, `COLLATION_NAME` varchar(32) DEFAULT NULL, `CHARACTER_SET_NAME` varchar(32) DEFAULTNULL, on data warehouse tables to ensure our departments data dictionary remains accurate. `DATETIME_PRECISION` bigint(21) unsignedDEFAULT NULL, Navicat Premium is a multi-connection database development and. Function browser dictionary of each function. Define, manage, save favorite queries access recent queries. `NUMERIC_SCALE` bigint(21) unsigned DEFAULTNULL, Write SQL queries with auto-completion, color syntax. `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‘, most complete list of data dictionary and database documentation tools on the web. `COLUMN_NAME` varchar(64) NOT NULL DEFAULT‘‘, `TABLE_NAME` varchar(64) NOT NULL DEFAULT ‘‘, `TABLE_SCHEMA` varchar(64) NOT NULL DEFAULT‘‘, `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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |