SELECT a.name AS TableName, b.name AS ColName, c.name AS ValType, b.length AS ValLength FROM sysobjects a INNER JOIN syscolumns b ON a.id = b.id INNER JOIN systypes c ON c.xtype = b.xtype WHERE a.xtype = ‘U‘ AND c.name != ‘sysname‘ --查询数据库中 表名 字段 数据类型 长度
原文：https://www.cnblogs.com/bamboo-140/p/9670213.html