从数据库中查看一个表中所有的字段

SELECT name
FROM   sys.all_columns
WHERE  object_id = (SELECT TOP 1 object_id
                    FROM   sys.all_objects
                    WHERE  name = 't1')