Use information_schema.columns to query the data table structure

 

Scenario 1: When writing a data dictionary (Word document,

The table structure needs to be obtained to speed up writing. Of course, the premise is that there is no document export tool.

 

Scenario 2: when an object is generated,

The premise is that there is no code generation tool.

 

Script

Select. column_name, case when. character_maximum_length is null then. data_type when. character_maximum_length is not null then convert (varchar (10),. data_type) + '(' + convert (varchar (10),. character_maximum_length) + ') 'end, case when. is_nullable = 'yes' then 'y' when. is_nullable = 'no' then' n' end from information_schema.columns as awhere. table_name = 'exam _ priority'

The result is as follows:

Use information_schema.columns to query the data table structure