SELECT
d.name TableName,
a.name FieldName,
b.name TypeName,
a.length Length,
a.isnullable IS_NULL
FROM
syscolumns a,
systypes b,
sysobjects d
d.name TableName,
a.name FieldName,
b.name TypeName,
a.length Length,
a.isnullable IS_NULL
FROM
syscolumns a,
systypes b,
sysobjects d
WHERE
a.xtype=b.xusertype
and a.id=d.id
and d.xtype='V' --视图 U是表 P存储过程
and d.name='account' --视图名