Teradata根据字段名查询表:
select top 100 databasename,tablename,columnname,columntitle,columntype from dbc.columns where databasename= 'iwi'
Teradata模糊查询表名:
select top 100 databasename,tablename from
dbc.tables
where tablename like '%iwi%'
Teradata根据字段名查询表:
select top 100 databasename,tablename,columnname,columntitle,columntype from dbc.columns where databasename= 'iwi'
Teradata模糊查询表名:
select top 100 databasename,tablename from
dbc.tables
where tablename like '%iwi%'