These SQL queries are useful when profiling any SQL Server database for later modelling or data migration tasks.
| 0 | Name | Usage |
|---|---|---|
| 1 | MD Columns | Shows column metadata |
| 2 | MD Constraints | Shows constraint metadata |
| 3 | MD Keys | Shows key metadata |
| 4 | MD Relations | Verifies relation row count metadata |
| 5 | MD Schemas | Shows schema metadata |
| 6 | MD Table Column Description | Shows table column metadata |
| 7 | MD Table Desc | Shows table metadata |
| 8 | MD Table Row Count | Shows table row count metadata |
| 8 | Date Cast or Convert | Low and high dates |
| 9 | Function RemoveNonAlphaCharacters | Removes chars for clean csv exports |