获取数据库中的表名字和表中列的名字

user databasename
go
select name from sysobjects where type='U' 
select name from syscolumns where id=object_id('TableName')