Bart Gawrych - Dataedo Team

Bart Gawrych

Database developer

Query Toolbox

IBM Db2 > Functions and stored procedures: List stored procedure parameters in Db2 database
IBM Db2 > Dependencies: Find objects used by specific stored procedure in Db2 database
IBM Db2 > Dependencies: Find objects used by specific function in Db2 database
IBM Db2 > Dependencies: Find tables and views used by specific view in Db2 database
Snowflake > Foreign keys: Loner Ratio - how many tables have no relationships in Snowflake
Snowflake > Foreign keys: List foreign keys in Snowflake
Snowflake > Foreign keys: Find tables without relationships - Loner Tables - in Snowflake
Snowflake > Foreign keys: Find tables that are not referenced by the foreign keys in Snowflake
Snowflake > Foreign keys: Find tables without foreign keys in Snowflake
Snowflake > Foreign keys: List tables with most foreign keys in Snowflake
Snowflake > Foreign keys: List tables with most relationships in Snowflake
Snowflake > Foreign keys: List most referenced tables (by FK) in Snowflake
Snowflake > Foreign keys: List all tables referencing a specific table (by FK) in Snowflake
Snowflake > Foreign keys: List all tables refrenced by specific table (by FK) in Snowflake
Oracle database > Dependencies: List of tables used by Materialized Views (MV dependencies) in Oracle database
Oracle database > Dependencies: Find tables that are not used by any other object
Oracle database > Dependencies: Find where specific stored procedure is used in Oracle database
Oracle database > Dependencies: Find where specific function is used in Oracle database
Oracle database > Dependencies: Find where specific table or view is used in Oracle database
Oracle database > Dependencies: List objects that use specific object in Oracle database
Oracle database > Jobs/events: List scheduled jobs in Oracle database
Oracle database > Indexes: List unique indexes in Oracle database
Oracle database > Indexes: List indexes on the table in Oracle database
Oracle database > Environment: How to find operating system (OS) that Oracle database runs on
2019-06-10

Query Toolbox

Oracle database > Schema compare: Compare tables and columns in two schemas in Oracle database
IBM Db2 > Schema compare: Compare tables and columns in two schemas in Db2 database
PostgreSQL > Schema compare: Compare tables and columns in two schemas in PostgreSQL database
Amazon Redshift > Schema compare: Compare tables and columns in two schemas in Redshift
Amazon Redshift > Data size: List of tables by their size in Redshift
Amazon Redshift > Environment: How to find operating system (OS) that server runs on
Amazon Redshift > Environment: How to check the Redshift version
Amazon Redshift > Session: Find last query executed by specific user in Redshift
Amazon Redshift > Session: Find queries executed in specific time range in Redshift
Amazon Redshift > Session: Terminate (kill) specific session on a server
Amazon Redshift > Session: Find last query executed by specific session in Redshift
Amazon Redshift > Security and users: List admins in Redshift
PostgreSQL > Data types: Find most used data type in PostgreSQL database
Amazon Redshift > Data types: Find most used data type in Redshift
PostgreSQL > Data size: List tables that take up 50% of space in PostgreSQL database
PostgreSQL > Functions and stored procedures: List stored procedure parameters in PostgreSQL database
PostgreSQL > Functions and stored procedures: List stored procedures in PostgreSQL database
PostgreSQL > Functions and stored procedures: List user defined functions (UDFs) in PostgreSQL database
PostgreSQL > Check constraints: List table check constraints in PostgreSQL database
PostgreSQL > Check constraints: List all check constraints in PostgreSQL database
Amazon Redshift > Data types: Find all date and time columns in Redshift
Amazon Redshift > Data types: Find all numeric columns in Redshift
Amazon Redshift > Foreign keys: Loner Ratio - how many tables have no relationships in Redshift
Amazon Redshift > Foreign keys: Find tables without relationships - Loner Tables - in Redshift
Amazon Redshift > Foreign keys: Find tables that are not referenced by the foreign keys in Redshift
Amazon Redshift > Foreign keys: Find tables without foreign keys in Redshift
Amazon Redshift > Foreign keys: List all tables refrencing specific table (by FK) in Redshift
Amazon Redshift > Foreign keys: List all tables refrenced by specific table (by FK) in Redshift
PostgreSQL > Foreign keys: Loner Ratio - how many tables have no relationships in PostgreSQL database
PostgreSQL > Foreign keys: Find tables without relationships - Loner Tables - in PostgreSQL database
PostgreSQL > Foreign keys: Find tables that are not referenced by the foreign keys in PostgreSQL database
PostgreSQL > Foreign keys: Find tables without foreign keys in PostgreSQL database
PostgreSQL > Foreign keys: List all tables refrencing specific table (by FK) in PostgreSQL database
PostgreSQL > Foreign keys: List all tables refrenced by specific table (by FK) in PostgreSQL database
PostgreSQL > Environment: How to find operating system (OS) that PostgreSQL server runs on
PostgreSQL > Triggers: List table triggers in PostgreSQL database
PostgreSQL > Data types: Find all enum columns in PostgreSQL database
PostgreSQL > Data types: Find all semi-structured data columns in PostgreSQL
PostgreSQL > Data types: Find all JSON data columns in PostgreSQL database
PostgreSQL > Data types: Find all XML data columns in PostgreSQL database
PostgreSQL > Data types: Find all geometric data columns in PostgreSQL database
PostgreSQL > Data types: Find all date and time columns in PostgreSQL database
PostgreSQL > Data types: Find all string (character) columns in PostgreSQL database
2019-06-03
Database & Data Modeling Tools, Aqua Data Studio 2019-05-15
Database & Data Modeling Tools, Azure Data Studio 2019-04-30
Database & Data Modeling Tools, Toad for SQL Server 2019-04-29
Database & Data Modeling Tools, Toad for SQL Server 2019-04-25
Database & Data Modeling Tools, Toad for SQL Server 2019-04-25
Database & Data Modeling Tools, Toad for SQL Server 2019-04-25
Pages: 1 2 3 4 5 6 7 8