SQL statement used to query the field information of the SQL Server table

1. 1. -- Query table description
   2. Select a. ID, A. Name, B. value from sysobjects
   3. Left join sysproperties B on A. ID = B. ID
   4. Where a. Name = 'userinfo'

2. Select
3. -- Table name = case when a. colorder = 1 then D. Name else ''end,
4. -- Table description = case when a. colorder = 1 then isnull (F. Value, '') else'' end,
5. FIELD No. = A. colorder,
6. Field name = A. Name,
7. Id = case when columnproperty (A. ID, A. Name, 'isidentity ') = 1 then' √ 'else' end,
8. Primary Key = case when exists (select 1 from sysobjects where xtype = 'pk' and name in (
9. Select name from sysindexes where indid in (
10. Select indid from sysindexkeys where id = A. ID and colid = A. colid
11. ) Then' √ 'else' end,
12. Type = B. Name,
13. Bytes occupied = A. length,
14. Length = columnproperty (A. ID, A. Name, 'precision '),
15. Decimal places = isnull (columnproperty (A. ID, A. Name, 'Scale'), 0 ),
16. Allow null = case when a. isnullable = 1 then '√ 'else' 'end,
17. Default Value = isnull (E. Text ,''),
18. Field description = isnull (G. [value], '')
19. From syscolumns
20. Left join policypes B on A. xtype = B. xusertype
21. Inner join sysobjects D on A. ID = D. id and D. xtype = 'U'
22. Left join syscomments e on A. cdefault = E. ID
23. Left join sysproperties g on A. ID = G. ID and A. colid = G. smallid
24. Left join sysproperties F on D. id = f. ID and F. smallid = 0
25. Where D. Name = 'table name' -- if only the specified table is queried, add this condition.
26. Order by A. ID, A. colorder

If you want to create an SQL Server tool and find the SQL above, you can write it down.