List all Tables and Columns in SQL Sever by data type

Created by
Thursday, July 28, 2016

This nifty little query gathers a list of all the database columns and tables they are contained in by their data type. 

 

SELECT table_name [Table Name], column_name [Column Name]
FROM information_schema.columns where data_type = 'float'

 

Below demonstrates its use for finding all columns of type 'varchar' in the standard master database.

 

0
Rating
1 2 3 4 5

Save

Saved

Report

Reported
Reasons
Cancel
0 comments