--list all tables and fields in a database
select sysobjects.name as TableName, syscolumns.name as FieldName, 
syscolumns.colorder as FldOrder 
from sysobjects inner join syscolumns on syscolumns.id = sysobjects.id 
where sysobjects.type = 'U'
order by sysobjects.name, syscolumns.colorder

List all tables and fields in database

SQL