My account Book a demo
Marcin Nagly - Dataedo Team

Marcin Nagly

Database specialist and systems engineer

Categories
Query Toolbox
IBM Db2 > Number of rows: List tables by the number of rows in Db2 database
IBM Db2 > Searching schema: Find tables with specific word in name in Db2 database
IBM Db2 > Foreign keys: Find tables without relationships - Loner Tables - in Db2 database
IBM Db2 > Views: List views columns in Db2 database
IBM Db2 > Foreign keys: Loner Ratio - how many tables have no relationships in Db2 database
IBM Db2 > Foreign keys: Find tables without foreign keys in Db2 database
IBM Db2 > Foreign keys: List tables with most relationships in Db2 database
2018-06-30
Query Toolbox
IBM Db2 > Primary keys: List tables with their primary keys (PKs) in Db2 database
IBM Db2 > Primary keys: Find tables without primary keys (PKs) in Db2 database
IBM Db2 > Primary keys: How many tables don't have primary keys (with percentage) in Db2 database
2018-06-29
Query Toolbox
IBM Db2 > Data types: Find tables with large object (LOB) data type columns in Db2 database
IBM Db2 > Data types: Find large object (LOB) data type columns in Db2 database
IBM Db2 > Triggers: List triggers in Db2 database
IBM Db2 > Foreign keys: List most referenced tables in Db2 database (by FK)
IBM Db2 > Foreign keys: List tables with most foreign keys in Db2 database
IBM Db2 > Schema naming: Get column name length distribution in Db2 database
IBM Db2 > Foreign keys: List table columns with their foreign keys in Db2 database
IBM Db2 > Foreign keys: List foreign keys with columns in Db2 database
IBM Db2 > Foreign keys: List foreign keys in Db2 database
2018-06-26
Query Toolbox
IBM Db2 > Searching schema: Find tables with names with specific prefix in Db2 database
IBM Db2 > Constraints: Check if is column nullable in Db2 database
IBM Db2 > Schema naming: List columns by name length in Db2 database
IBM Db2 > Schema naming: Find most popular column names in Db2 database
IBM Db2 > Schema statistics: List tables with the largest number of columns in Db2 database
IBM Db2 > Schema statistics: Find number of tables in Db2 database
IBM Db2 > Searching schema: Find table that DON'T have a column with specific name in Db2 database
IBM Db2 > Searching schema: Find tables with specific column name in Db2 database
IBM Db2 > Searching schema: Find tables with names with specific suffix in Db2 database
IBM Db2 > Searching schema: Find tables with digits in names in db2 database
IBM Db2 > Searching schema: Find a table by the name in Db2 database
IBM Db2 > Databases and schemas: List user created schemas in Db2 database
IBM Db2 > Triggers: List triggers by table name in Db2 database
2018-06-25
Query Toolbox
IBM Db2 > Views: List views in IBM Db2 database with their scripts
2018-06-24