I developed code that lists the columns, types and attributes (below) and it lists what I need.
In SysObjects, I can see xtype = 'u' as the selection criteria but how can I iterate through all tables in the database so that I will get a continuous listing of the columns, types and attributes?
t.TABLE_NAME as 'Table', c.COLUMN_NAME as 'Column Name' ,c.DATA_TYPE as 'Type' ,c.CHARACTER_MAXIMUM_LENGT
H as 'Length',c.NUMERIC_PRECISI
ON as 'Numeric length',c.NUMERIC_SCALE as 'Decimals',c.DATETIME_PREC
ISION as 'Date/Time'
from INFORMATION_SCHEMA.Tables t
INNER JOIN INFORMATION_SCHEMA.Columns
c ON t.TABLE_CATALOG=c.TABLE_CA
TALOG AND t.TABLE_SCHEMA=c.TABLE_SCH
EMA AND t.TABLE_NAME=c.TABLE_NAME
ORDER BY t.TABLE_NAME, c.COLUMN_NAME