sales@dataedo.com
+1 609-849-3393
My account
Search
product
product
Data Catalog
Data Community
Business Glossary
Data Profiling
Data Lineage
Reference Data Management
Report Catalog
Sensitive Data Discovery
Data Dictionary
Database Documentation
ER Diagrams
Schema Change Tracking
Supported
Technologies
See all features →
Solutions
Solutions
Metadata Management: Why Start Now?
By Use Case
Business Intelligence
Data Warehousing
Data Governance
Data Protection
Metadata Management
All Use Cases
By Industry
Financial Services
Healthcare
Public & Government
Education
Technology
All Industries
By Technology
SQL Server
Snowflake
Power BI
Azure
AWS
Supported Technologies
See all →
Pricing
Company
Why Dataedo?
About us
Careers
Our Customers
Case Studies
Testimonials
Contact Us
Resources
Resources
Dataedo Cartoons
General
Blog
Webinars
Videos
Library
Dataedo Cartoons
Dataedo
Documentation
Tutorials
Support
Contact support
Documentation
Tutorials
Get a demo
Get a demo
Free trial
Free trial
Bart Gawrych
Database developer
Contributors
Bart Gawrych
Categories
All
KB (36)
Queries (544)
Query Toolbox
Snowflake > Schema compare: Compare tables and columns in two schemas in Snowflake
Snowflake > Schema compare: Compare tables and columns in two databases in Snowflake
Snowflake > Data size: List 10 largest tables in Snowflake
Snowflake > Data size: List tables by their size in Snowflake
Snowflake > Constraints: List all table constraints (PK, FK, Unique, Default) in Snowflake
Snowflake > Default values: Compare default values of different columns with the same name in Snowflake database
2023-01-05
Query Toolbox
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 > 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 > Default values: Compare default values of different columns with the same name in Vertica database
Vertica > Constraints: Check if is column nullable 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 > 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 statistics: Find number of tables in Vertica database
Vertica > Schema statistics: Find number of columns in Vertica database
Vertica > Schema naming: Get column name length distribution in Vertica database
Vertica > Security and users: List admins in Vertica
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 > Data size: List 10 largest tables in Vertica database
Vertica > Data usage: Find the time when table was last accessed in Vertica database
Vertica > Schema compare: Compare tables and columns in two schemas in Vertica database
Vertica > Data usage: Find tables not accessed for past n months 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 > Unique keys: List unique keys and their columns in Vertica database
Vertica > Default values: Summary of default values in Vertica database
Vertica > Data types: Find most used data type 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 > Number of rows: Number of tables by the number of rows in Vertica database
Teradata > Primary keys: List tables with their primary keys (PKs) 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 > Unique keys: List unique keys and indexes in Teradata database
Teradata > Check constraints: List table check constraints in Teradata database
Teradata > Default values: List table default values in Teradata database
Teradata > Default values: Summary of default values 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 > Data types: Find most used data type 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 > Schema statistics: List tables with the largest number of columns in Teradata database
Teradata > Schema naming: List columns by name length 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 > Tables: List temporal tables 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 > Functions and stored procedures: List stored procedures in Teradata database
Teradata > Functions and stored procedures: List stored procedure parameters in Teradata database
Teradata > Security and users: List users in Teradata database
Teradata > Number of rows: List tables by the number of rows 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 > Number of rows: Number of tables by the number of rows in Teradata database
Teradata > Columns: List all table columns with details (PKs, UKs, FKs, Default, Checks, Computed, etc.) in Teradata database
Teradata > Schema compare: Compare tables and columns in two databases in Teradata database
Teradata > Data types: Find all semi-structured data columns 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 > Constraints: Find required (non nullable) 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 > Searching schema: Find table that DON'T have a column with specific name in Teradata database
Teradata > Schema statistics: Find number of columns 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 > Tables: Find recently modified tables in Teradata database
Teradata > Foreign keys: Find tables that are not referenced by the foreign keys in Teradata database
Teradata > Default values: Compare default values of different columns with the same name 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 > Session: Find queries executed in specific time range 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 > Number of rows: Find empty tables 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
Query Toolbox
MySQL > Schema compare: Compare tables and columns in two schemas in MariaDB database
MySQL > Columns: List all table columns with details (PKs, UKs, FKs, Default, Computed, etc.) in MySQL database
2019-09-23
Query Toolbox
Vertica > Databases and schemas: List schemas in Vertica database
Vertica > Databases and schemas: List user created schemas in Vertica database
Vertica > Number of rows: Find empty tables in Vertica database
Vertica > Number of rows: List tables by the number of rows in Vertica
Vertica > Columns: List all columns in specific table in Vertica database
Vertica > Columns: List table columns in Vertica database
Vertica > Tables: Find recently created tables in Vertica database
Vertica > Tables: List tables in Vertica database schema
Vertica > Tables: List tables in Vertica database
2019-09-17
DataGrip > Schema comments: How to view and edit trigger comment
Database & Data Modeling Tools
2019-09-17
DataGrip > Exploring schema: How to view stored routine code with JetBrains DataGrip
Database & Data Modeling Tools
2019-09-17
DataGrip > Schema comments: How to view and edit table and column comments with JetBrains DataGrip
Database & Data Modeling Tools
2019-09-17
DataGrip > Exploring schema: How to find table in a database with JetBrains DataGrip
Database & Data Modeling Tools
2019-09-17
DataGrip > Exploring schema: How to view table foreign keys (FK) in JetBrains DataGrip
Database & Data Modeling Tools
2019-09-17
DataGrip > Database diagrams: How to create ER diagram for existing database with DataGrip
Database & Data Modeling Tools
2019-09-17
Toad for IBM DB2 > Schema comments: How to view and edit trigger comment with Toad for Db2
Database & Data Modeling Tools
2019-09-17
Toad for IBM DB2 > Modifying schema: How to create Foreign Key with Toad for IBM DB2
Database & Data Modeling Tools
2019-09-17
1
2
3
4
5
6
7
8
9
Next