SQL查询表跟字段

SELECT T.name,C.name FROM SYSOBJECTS T LEFT JOIN SYSCOLUMNS C ON  C.id=OBJECT_ID(T.name)
WHERE T.type='U' AND t.name LIKE '%TABLE%' ORDER BY t.name,c.name