select name from sysobjects where xtype = 'U' order by name go select a.name, b.name from sysobjects a, syscolumns b where a.id = b.id and a.xtype = 'U' order by a.name, b.name
select a.name as tablename,b.name as colname from sysobjects a,syscolumns b where a.id=b.id and a.type='u' order by a.name,b.colid
go
select a.name, b.name from sysobjects a, syscolumns b where a.id = b.id and a.xtype = 'U' order by a.name, b.name
from sysobjects a,syscolumns b
where a.id=b.id
and a.type='u'
order by a.name,b.colid