yuxuac的专栏

select schema_name(fk_tab.schema_id) + '.' + fk_tab.name as foreign_table, '>-' as rel, schema_name(pk_tab.schema_id) + '.' + pk_tab.name as primary_table, substring(column_names, 1, len(column_names)-1) as [fk_columns], fk.name as fk_c.

转自：https://www.codeproject.com/articles/33052/visual-representation-of-sql-joins

select *from [YourDBName].information_schema.columnsorder by table_name, ordinal_position

http://www.cnblogs.com/coy/archive/2013/01/17/2860753.html

SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36,

1. 修改注册表，添加以下键值（编辑文本文件，填入以下内容，修改后缀为reg，双击执行）Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\SideBySide]"PreferExternalManifest"=dword:000000012. 找到...

https://github.com/cjlee/northwind