Oracle
select a.table_name,b.COLUMN_NAME,b.DATA_TYPE from user_tables a
left join user_tab_columns b on a.table_name=b.table_name
where b.DATA_TYPE=‘TIMESTAMP(6)‘;
SQL Server
select b.name ColumnName,c.name SystemTypeName,a.name tablename,b.precision,b.scale from sys.tables a
left join sys.columns b on a.object_id=b.object_id
left join sys.types c on b.system_type_id=c.system_type_id
where c.name=‘date‘;
Oracle&SQL Server 表名、字段查询
标签:rac tab pre ble precision sys obj use acl
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源:https://www.cnblogs.com/aDoc/p/12884213.html