SELECT sobjects.name
FROM sysobjects sobjects
WHERE sobjects.xtype = 'U'
SELECT OBJECT_SCHEMA_NAME(T.[object_id],DB_ID()) AS 'Schema',
T.[name] AS 'Table name',
AC.[name] AS 'Column name',
TY.[name] AS 'Data type',
AC.[max_length] as 'Size',
AC.[precision] as 'Precision',
AC.[scale] as 'Scale',
AC.[is_nullable] as 'Is Nullable'
FROM sys.[tables] AS T
INNER JOIN sys.[all_columns] AC
ON T.[object_id] = AC.[object_id]
INNER JOIN sys.[types] TY ON AC.[system_type_id] = TY.[system_type_id] AND AC.[user_type_id] = TY.[user_type_id]
WHERE T.[is_ms_shipped] = 0
and T.[name] not in ('sysdiagrams') -- List tables here to not include in the list
ORDER BY
T.[name],
AC.[column_id]
