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

You need to export the fields and properties of the table in the database, make a table and save it to word.

First find the library you want to import and enter sql on the query page

SELECT COLUMN_NAME column name, COLUMN_TYPE data type, DATA_TYPE field type, CHARACTER_MAXIMUM_LENGTH length, whether IS_NULLABLE is empty, COLUMN_DEFAULT default value, COLUMN_COMMENT remarks FROM INFORMATION_SCHEMA.COLUMNSwheretable_schema = 'library name' ANDtable_name = 'table name'

Get the result

And then copy it, and you can copy the result.

Note that what is copied is the content, and there is no header and table format. You need to draw a table of the right size on word, and then paste the data on it.

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.