就业数据资源平台
当前位置:首页 > 数据库技术
怎样才能导出SQL所有用户表的字段信息

  问题:怎样才能导出SQL所有用户表的字段?
  解答:请使用下面的Sql语句:
  SELECT
  表名,
  a.colorder 字段序号,
  a.name 字段名,
  =1 then ‘√‘else ‘‘ end) 标识,
  FROM sysobjects
  WHERE AND AND AND )))))) AND
  )0 then ‘√‘ else ‘‘ end) 主键,
  b.name 类型,
  a.length 占用字节数,
  COLUMNPROPERTY as 长度,
  isnull,0) as 小数位数,
  答应空,
  isnull 默认值,
  isnull AS 字段说明
  FROM syscolumns a left join systypes b
  on a.xtype=b.xusertype
  inner join sysobjects d
  on a.id=d.id and d.xtype=‘U‘ and d.name‘dtproperties‘
  left join syscomments e
  on a.cdefault=e.id
  left join sysproperties g
  on a.id=g.id AND a.colid = g.smallid
  order by a.id,a.colorder
就业数据资源平台