表添加字段

ALTER TABLE `dmp_sales_forecast`.ims_sales_forecast_demand_plan_order ADD COLUMN `product_desc` VARCHAR ( 200 ) NULL COMMENT '國(guó)內(nèi)物料描述(產(chǎn)品描述)' AFTER `product_name`,LOCK = NONE;

表&字段信息

SELECT

'訂單系統(tǒng)',

t.TABLE_SCHEMA as '庫(kù)名/SCHEMA',

t.TABLE_NAME as'表名',

t.TABLE_COMMENT as '表注釋',

c.COLUMN_NAME as '列名',

c.COLUMN_COMMENT as '列注釋',

c.COLUMN_DEFAULT as '默認(rèn)值',

c.IS_NULLABLE as '是否為空',

c.COLUMN_TYPE as '列類型',

c.NUMERIC_PRECISION as '數(shù)值精度（最大位數(shù)）',

c.NUMERIC_SCALE as '小數(shù)精度',

c.COLUMN_KEY as '主鍵',

c.EXTRA as '額外說明',

t.TABLE_ROWS

FROM

information_schema.TABLES t left join information_schema.`COLUMNS` c on t.TABLE_NAME = c.TABLE_NAME and t.TABLE_SCHEMA = c.TABLE_SCHEMA

WHERE t.TABLE_SCHEMA='dmp_sales_order' and t.TABLE_ROWS > 0

order by t.TABLE_NAME, c.COLUMN_NAME;