达梦数据库查询字段类型为Date 修改为DateTime

 

 

SELECT 'ALTER TABLE ' || OWNER || '.' || TABLE_NAME || ' MODIFY ' || COLUMN_NAME || ' DATETIME;' AS alter_sql
FROM ALL_TAB_COLUMNS
WHERE DATA_TYPE = 'DATE' and OWNER='PS_EXAMPLEDBUSER'
order by COLUMN_NAME asc

 

SELECT 'ALTER TABLE ' || OWNER || '.' || TABLE_NAME || ' MODIFY ' || COLUMN_NAME || ' nvarchar(' || DATA_LENGTH ||');' AS alter_sql
FROM ALL_TAB_COLUMNS
WHERE DATA_TYPE = 'VARCHAR' and OWNER='PS_EXAMPLEDBUSER'
order by COLUMN_NAME asc