If I execute "sp_help Table_1" I see the extended properties of the columns, like:
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
SomeTextCHAR nchar no 60 yes (n/a) (n/a) SQL_Latin1_General_CP1_CI_AS
SomeTextVARCHAR varchar no 50 yes no yes SQL_Latin1_General_CP1_CI_AS
I would like to execute a query that will list all the extended properties of all the columns in all the tables in my database, or rather specifically the "TrimTrailingBlanks" property.
Is this possible?