SQL Server method for generating table structure documents

Just say the principle, you can use the program to generate HTM or Word documents.

1, first get all the tables

SELECT name, id from sysobjects WHERE xtype = ' u ' ORDER by name ASC

2. Query the field information according to the table name

Select Syscolumns.name, Syscolumns.length, Systypes.name as TypeName, Sys.extended_properties. [Value] As tname,syscolumns.isnullable from Syscolumns joins systypes on Syscolumns.xtype=systypes.xtype and systypes. Name <> ' sysname ' left OUTER JOIN sys.extended_properties on (sys.extended_properties.minor_id = Syscolumns.colid A   ND sys.extended_properties.major_id = syscolumns.id) where syscolumns.id in (the Select ID from sysobjects where Name= ' T_sale ')

SQL Server method for generating table structure documents