查寻数据中包含某个字段的数据表
查找数据中包含某个字段的数据表
select t.COLUMN_ID ColID,
t.COLUMN_NAME ColName,
ts.table_name,
c.COMMENTS ColDescription,
t.DATA_TYPE TypeName,
t.data_Length Length,
t.CHAR_Length CharLength,
t.DATA_DEFAULT DefaultValue
from user_tab_columns t
left join user_col_comments c on t.TABLE_NAME = c.table_name
and t.COLUMN_NAME = c.column_name,
user_tables ts
where t.TABLE_NAME = ts.table_name
and (t.COLUMN_NAME = 'PROJECT_GUID');