主题：如何获取sql数据库的表的字段名和字段类型和长度

比如

select a.name, b.name, a.length from syscolumns a inner join systypes b on a.xtype=b.xtype where id=object_id('表A')

http://www.foxtable.com/bbs/dispbbs.asp?BoardID=2&ID=99369&replyID=684344&skin=1

https://www.cnblogs.com/xjiao/p/6019775.html