sql数据库获取表名称和表列名

select * from sysobjects where xtype='u'
SELECT COLUMN_NAME,DATA_TYPE FROM INFORMATION_SCHEMA.columns WHERE TABLE_NAME='表名'