In this post, I’ll continue with generating a list of columns.
Mediawiki table how to#
In my previous post, I showed how to create a SQL Script that generates Mediawiki mark-up to create a list of tables (or views) in your database. This is how the resulting mediawiki code renders in the browser.Ĭreating a data dictionary with SQL Server and MediaWiki – Part two: a list of columns WHERE PK.TABLE_SCHEMA = PK.TABLE_NAME = PK.TABLE_CATALOG = BY FK.TABLE_SCHEMA, FK.TABLE_NAME, CU.COLUMN_NAME ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK SELECT FK.TABLE_CATALOG, FK.TABLE_SCHEMA, FK.TABLE_NAME, CU.COLUMN_NAMEįROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C Edit these parameters to suit your needs. The is the name of the database, the and are the names of the destination schema and table. a list of other tables that reference this one) The scriptĪt the top of the script are three parameters that you need to set to suit your needs. In this post I continue that by showing how to generate a list of inbound links (i.e. In my previous posts (parts one and two), I showed how to generate mediawiki markup to generate lists of tables and columns that can be used as the starting blocks of a data dictionary.
0 kommentar(er)
