Tip: Get All Columns in All Tables of a Specific Data Type

See how to find a specific data type across all tables and columns in a database.

by Hannes Du Preez

Oct 31, 2019

We can get all columns in all tables of a specific data type. The example below gets all INT columns in the entire database

SELECT OBJECT_NAME(sys.columns.OBJECT_ID) as TableName, sys.columns.name as ColumnName  
  
FROM sys.columns  
  
JOIN sys.types ON sys.columns.user_type_id = sys.types.user_type_id  
  
WHERE sys.types.name = 'INT'

Thanks for your registration, follow us on our social networks to keep up-to-date