Bart Gawrych - Dataedo Team

Bart Gawrych

Database developer

Query Toolbox

Vertica > Data size: List 10 largest tables in Vertica database
Vertica > Schema statistics: Find number of tables in Vertica database
Vertica > Schema statistics: Find number of columns in Vertica database
Vertica > Foreign keys: Find tables that are not referenced by the foreign keys in Vertica database
Vertica > Foreign keys: Find tables without relationships - Loner Tables - in Vertica database
Vertica > Searching schema: Find a table by the name in Vertica database
Vertica > Searching schema: Find tables with names with specific prefix in Vertica database
Vertica > Searching schema: Find tables with names with specific suffix in Vertica database
Vertica > Searching schema: Find tables with specific word in name in Vertica database
Vertica > Searching schema: Find tables with digits in names in Vertica database
Vertica > Searching schema: Find tables with specific column name in Vertica database
Vertica > Searching schema: Find table that DON'T have a column with specific name in Vertica database
Vertica > Schema compare: Compare tables and columns in two schemas in Vertica database
Vertica > Schema naming: Get column name length distribution in Vertica database
Vertica > Security and users: List admins in Vertica
Vertica > Data usage: Find the time when table was last accessed in Vertica database
Vertica > Data usage: Find tables not accessed for past n months in Vertica database
Vertica > Session: Find last query executed by specific session in Vertica database
Vertica > Session: Terminate (kill) specific session in Vertica database
Vertica > Session: Find last query executed by specific user in Vertica
Vertica > Session: Find queries executed in specific time range in MariaDB database
Vertica > Primary keys: Find tables without primary keys (PKs) in Vertica database
Vertica > Primary keys: How many tables don't have primary keys (with percentage) in Vertica database
Vertica > Data types: Find all numeric columns in Vertica database
Vertica > Data types: Find all string (character) columns in Vertica database
Vertica > Data types: Find all date and time columns in Vertica database
Vertica > Constraints: Check if is column nullable in Vertica database
Vertica > Default values: Compare default values of different columns with the same name in Vertica database
Vertica > Primary keys: List all primary keys (PKs) and their columns in Vertica database
Vertica > Foreign keys: List all tables refrenced by specific table (by FK) in Vertica database
Vertica > Foreign keys: List all tables refrencing specific table (by FK) in Vertica database
Vertica > Session: List sessions / active connections in Vertica database
Vertica > Foreign keys: List most referenced tables in Vertica database (by FK)
Vertica > Schema naming: List columns by name length in Vertica database
Vertica > Foreign keys: List foreign keys with columns in Vertica database
Vertica > Data size: List tables by their size in Vertica database
Vertica > Schema statistics: List tables with the largest number of columns in Vertica database
Vertica > Tables: List projections in Vertica database
Vertica > Default values: List table default values in Vertica database
Vertica > Foreign keys: List table columns with their foreign keys in Vertica database
Vertica > Views: List views in Vertica database
Vertica > Views: List views in Vertica database with their scripts
Vertica > Views: List views columns in Vertica
Vertica > Foreign keys: List tables with most relationships in Vertica database
Vertica > Foreign keys: Find tables without foreign keys in Vertica database
Vertica > Foreign keys: Loner Ratio - how many tables have no relationships in Vertica database
Vertica > Foreign keys: List tables with most foreign keys in Vertica database
Vertica > Number of rows: Number of tables by the number of rows in Vertica database
Vertica > Functions and stored procedures: List user defined functions (UDFs) in Vertica database
Vertica > Schema naming: Find most popular column names in Vertica database
Vertica > Security and users: List users in Vertica database
Vertica > Data types: Find most used data type in Vertica database
Vertica > Default values: Summary of default values in Vertica database
Vertica > Unique keys: List unique keys and their columns in Vertica database
Teradata > Tables: List temporal tables in Teradata database
Teradata > Data size: List tables by their size in Teradata database
Teradata > Data size: List idexes by their size in Teradata database
Teradata > Schema statistics: List tables with the largest number of columns in Teradata database
Teradata > Foreign keys: List foreign keys in Teradata database
Teradata > Foreign keys: List foreign keys with columns in Teradata database
Teradata > Foreign keys: List table columns with their foreign keys in Teradata database
Teradata > Foreign keys: List all tables refrenced by specific table (by FK) in Teradata database
Teradata > Foreign keys: List all tables refrencing specific table (by FK) in Teradata database
Teradata > Foreign keys: List tables with most foreign keys in Teradata database
Teradata > Foreign keys: List most referenced tables (by FK) in Teradata
Teradata > Foreign keys: List tables with most relationships in Teradata
Teradata > Foreign keys: Find tables without foreign keys in Teradata database
Teradata > Foreign keys: Find tables without relationships - Loner Tables - in Teradata database
Teradata > Foreign keys: Loner Ratio - how many tables have no relationships in Teradata database
Teradata > Number of rows: List tables by the number of rows in Teradata database
Teradata > Number of rows: Number of tables by the number of rows in Teradata database
Teradata > Triggers: List triggers in Teradata database
Teradata > Triggers: List triggers by table name in Teradata database
Teradata > Functions and stored procedures: List user defined functions (UDFs) in Teradata database
Teradata > Functions and stored procedures: List stored procedures in Teradata database
Teradata > Functions and stored procedures: List stored procedure parameters in Teradata database
Teradata > Schema naming: List columns by name length in Teradata database
Teradata > Security and users: List users in Teradata database
Teradata > Session: List sessions / active connections in Teradata database
Teradata > Session: Find last query executed by specific user in Teradata database
Teradata > Columns: List all table columns with details (PKs, UKs, FKs, Default, Checks, Computed, etc.) in Teradata database
Teradata > Primary keys: List tables with their primary keys (PKs) in Teradata database
Teradata > Data types: Find most used data type in Teradata database
Teradata > Check constraints: List table check constraints in Teradata database
Teradata > Constraints: List all table constraints (PK, UK, FK, Check & Default) in Teradata database
Teradata > Indexes: List table indexes in Teradata database
Teradata > Default values: List table default values in Teradata database
Teradata > Default values: Summary of default values in Teradata database
Teradata > Unique keys: List unique keys and indexes in Teradata database
Teradata > Schema compare: Compare tables and columns in two databases in Teradata database
Teradata > Tables: Find recently modified tables in Teradata database
Teradata > Schema statistics: Find number of columns in Teradata database
Teradata > Foreign keys: Find tables that are not referenced by the foreign keys in Teradata database
Teradata > Number of rows: Find empty tables in Teradata database
Teradata > Searching schema: Find table that DON'T have a column with specific name in Teradata database
Teradata > Data usage: Find the time when table was last accessed in Teradata database
Teradata > Data usage: Find tables not accessed for past n months in Teradata database
Teradata > Session: Find last query executed by specific session in Teradata database
Teradata > Session: Terminate (kill) specific session on a server
Teradata > Session: Find queries executed in specific time range in Teradata database
Teradata > Primary keys: List all primary keys (PKs) and their columns in Teradata database
Teradata > Primary keys: Find tables without primary keys (PKs) in Teradata database
Teradata > Primary keys: How many tables don't have primary keys (with percentage) in Teradata database
Teradata > Data types: Find all semi-structured data columns in Teradata database
Teradata > Data types: Find large object (LOB) data type columns in Teradata database
Teradata > Data types: Find tables with large object (LOB) data type columns in Teradata database
Teradata > Data types: Find all numeric columns in Teradata database
Teradata > Data types: Find all string (character) columns in Teradata database
Teradata > Data types: Find all date and time columns in Teradata database
Teradata > Data types: Find all XML data columns in Teradata database
Teradata > Data types: Find all JSON data columns in Teradata database
Teradata > Constraints: Find required (non nullable) columns in Teradata database
Teradata > Default values: Compare default values of different columns with the same name in Teradata database
Teradata > Schema naming: Get column name length distribution in Teradata database
Teradata > Constraints: Check if is column nullable in Teradata database
2019-10-31
Database & Data Modeling Tools, DataGrip 2019-09-17
Database & Data Modeling Tools, DataGrip 2019-09-17
Database & Data Modeling Tools, DataGrip 2019-09-17
Database & Data Modeling Tools, DataGrip 2019-09-17
Database & Data Modeling Tools, DataGrip 2019-09-17
Database & Data Modeling Tools, DataGrip 2019-09-17
Database & Data Modeling Tools, Toad for IBM DB2 2019-09-17
Database & Data Modeling Tools, Toad for IBM DB2 2019-09-17
Database & Data Modeling Tools, Toad for IBM DB2 2019-09-17
Pages: 1 2 3 4 5 6 7 8

By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).
Accept