获取SQL数据库中的数据库名、所有表名、所有字段名、列描述（国外英文资料）.docVIP

获取SQL数据库中的数据库名、所有表名、所有字段名、列描述（国外英文资料） syscolumns Each column in each table and view occupies a row in the table, and each parameter in the stored procedure also occupies a row in the table. The table is in each database. Column name data type description The name sysname The name of the column name or procedure parameter. id int This column belongs to the table object ID, or the stored procedure ID associated with that parameter. xtype tinyint The physical storage type in systypes. typestat tinyint Internal use only. xusertype smallint The extended user defines the data type ID. length smallint Maximum physical storage length in systypes. xprec tinyint Internal use only. Xscale wasnt entirely tinyint Internal use only. colid smallint Column or parameter ID. xoffset smallint Internal use only. bitpos tinyint Internal use only. reserved tinyint Internal use only. colstat smallint Internal use only. cdefault int The default value of the column is ID. domain int The rule of the column or the CHECK constraint ID. number smallint The subprocess number of the procedure group (0 for the non-process item). colorder smallint Internal use only. autoval Varbinary (255). Internal use only. offset smallint The amount of offsets that the column is in; If it is negative, it represents a variable length row. The status tinyint A bitmap for describing column or parameter properties: 0x08 = column allows null values. 0x10 = when adding varchar or varbinary columns, ANSI fills in. Keep the trailing Spaces of the varchar column, and leave the trailing zeros of the varbinary column. 0x40 = parameter is the OUTPUT parameter. 0x80 = listed as the identity column. The type tinyint The physical storage type in systypes. usertype smallint The user in systypes defines the data type ID. printfmt Varchar (255) Internal use only. prec smallint The precision level of the column. scale int The decimal number of this column. iscomputed int Indicates whether or not the column has been computed: 0 = u