Based on datatype to find the all table and column for particular database
SELECT TA.name,C.name,T.name FROM SYS.TYPES T INNER JOIN SYS.COLUMNS CON T.system_type_id = C.system_type_id INNER JOIN SYS.TABLES TA ON TA.OBJECT_ID = C.OBJECT_IDWHERE t.name = 'money'
SELECT TA.name,C.name,T.name FROM SYS.TYPES T INNER JOIN SYS.COLUMNS CON T.system_type_id = C.system_type_id INNER JOIN SYS.TABLES TA ON TA.OBJECT_ID = C.OBJECT_IDWHERE t.name = 'money'
Its Simple Lokesh
ReplyDelete