Can we list all tables and views having a specific column names

1

Experts,

Can we list all tables and views having a specific column names by writing SQL queries or any other way like UI in Dremio. I am wondering about some thing like in database where we can scan metadata tables.

I tried to execute below query
SELECT * FROM INFORMATION_SCHEMA.COLUMNS

However getting below error-

image
image917×417 23.1 KB

Thanks

2

@rajneesh4u Looks like there is a table with data type MICRO which will run into this error. Any chance you would know the table_name?

3

Hi Bala ji, No I don’t know the table. However my understanding is that regardless of data type I should get table names listed.

Thanks,
Rajneesh