SQL query to get the largest data type in the schema

advertisements

What is the query to get the top 5 ...data types ...used in a DB by size? blob > int


The sys.types and sys.systypes have some of that info, play around with these queries

select *
from sys.types

select *
from sys.systypes