CODEWITHSUNDEEP
sqldatabasesqldatatypes
Amol Bavannavar
Amol Bavannavar

Reputation: 2062

Get table names from database, which contains particular data type column

I want to get all the Table Names from database which Table has a Column with particular DataType.

Let's say image is the DataType, then I want to find all the Table Names which have one or more column of image type in it.

Upvotes: 0

Views: 319

Answers (1)

jarlh
jarlh

Reputation: 44796

select * from information_schema.columns

Add where DATA_TYPE = 'datatype' to get columns of a specific type.

(This is ANSI/ISO SQL standard, not supported by all dbms products.)

Upvotes: 1

Related Questions