SQL Server导出表或View的字段名与数据类型

SELECT 
	SO.NAME AS VIEWNAME,
	SC.NAME AS CLUMNNAME,
	SC.COLID AS [INDEX],
	ST.NAME AS [TYPE]
FROM
	SYSOBJECTS SO,
	SYSCOLUMNS SC,
	SYSTYPES ST
WHERE 
	SO.ID = SC.ID
	AND SO.XTYPE='U'
	AND SO.STATUS >= 0
	AND SC.XTYPE = ST.XUSERTYPE
	AND SO.NAME = 'PAD_EV_BIGPERFORMANCE'
ORDER BY 
	SO.NAME

其中SO.XTYPE的值如果是“U”的话，表示查询的是表

如果是“V”的话，表示查询的是视图

SO.NAME的值是表或VIEW的值