How To search a field of particular Data Type in any Table using T-SQL?

To get a field of particular Data Type in any Table

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE DATA_TYPE like '%INT%'

1 comment:

Mr Lonely said...

nice blog.. have a view of my blog when free.. http://www.lonelyreload.blogspot.com .. do leave me some comment / guide if can.. if interested can follow my blog...