Query:
When there are too many tables to be queried, it is annoying to manually write SQL statements. One way is to right-click the table, open the table, and query it. In addition, there are multiple table links, left join, etc,
Modify the table result dynamically. First, press the table designer to modify the table. Then, when you click the script icon of the tool class, the Enterprise Manager will automatically generate the required Code,
Another
An SQL statement for getting table information
Select
Field name = A. Name,
Type = B. Name,
Bytes occupied = A. length,
Field description = isnull (G. [value], '')
From syscolumns a left join policypes B on A. xtype = B. xusertype
Inner join sysobjects D on A. ID = D. id
And D. xtype = 'U' and
D. Name = 'info'
Left join sysproperties g on A. ID = G. ID and A. colid = G. smallid
Order by A. colorder
