sales@dataedo.com
+1 704-387-5078
My account
Search
product
product
Our Products
Data Catalog
Data Community
Business Glossary
Data Profiling
Data Dictionary
Database Documentation
Schema Change Tracking
Sensitive Data Discovery
ER Diagrams
Data Lineage
Metadata Scanners
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
All Technologies
See all →
Pricing
Company
About us
Why Dataedo?
Our Customers
Case Studies
Testimonials
Contact Us
Resources
Resources
Dataedo Data Cartoons
General
Blog
Webinars
Videos
Data Knowledge Base
Library
Cartoon
Dataedo
Documentation
Repository docs
Tutorials
Samples
Support
Contact support
Support forum
Documentation
Repository docs
Tutorials
Get a demo
Get a demo
Free trial
Free trial
Bart Gawrych
Database developer
Contributors
Bart Gawrych
Categories
All
KB (36)
Queries (538)
Query Toolbox
Snowflake > Schema statistics: Average number of columns per table in Snowflake
Snowflake > Security and users: List users in Snowflake
2018-12-20
Query Toolbox
Amazon Redshift > Foreign keys: List most referenced tables (by FK) in Redshift
PostgreSQL > Foreign keys: List most referenced tables in PostgreSQL database (by FK)
Amazon Redshift > Foreign keys: List tables with most foreign keys in Redshift
PostgreSQL > Foreign keys: List tables with most foreign keys in PostgreSQL database
Amazon Redshift > Foreign keys: List foreign keys with columns in Redshift
Amazon Redshift > Primary keys: How many tables don't have primary keys (with percentage) in Redshif
Amazon Redshift > Primary keys: Find tables without primary keys (PKs) in Redshift
Amazon Redshift > Primary keys: List all primary keys (PKs) and their columns in Redshift
PostgreSQL > Session: Terminate (kill) specific session in PostgreSQL database
PostgreSQL > Number of rows: Number of tables by the number of rows in PostgreSQL database
PostgreSQL > Number of rows: List tables by the number of rows in PostgreSQL database
Amazon Redshift > Number of rows: Number of tables by the number of rows in Redshift
Amazon Redshift > Number of rows: List tables by the number of rows in Redshift
Amazon Redshift > Number of rows: Find empty tables in Redshift
2018-12-18
Query Toolbox
Amazon Redshift > Default values: Summary of default values in Redshift
PostgreSQL > Schema naming: Find most popular column names in PostgreSQL database
PostgreSQL > Environment: How to check the PostgreSQL version
Oracle database > Number of rows: Number of tables by the number of rows in Oracle database
Oracle database > Number of rows: List tables by the number of rows in Oracle database
Oracle database > Number of rows: Find empty tables in Oracle database
IBM Db2 > Number of rows: Number of tables by the number of rows in Db2 database
IBM Db2 > Number of rows: Find empty tables in Db2 database
IBM Db2 > Schema statistics: Average number of columns per table in Db2 database
IBM Db2 > Foreign keys: List all tables refrencing specific table (by FK) in Db2 database
IBM Db2 > Foreign keys: List all tables refrenced by specific table (by FK) in Db2 database
2018-12-17
Query Toolbox
Amazon Redshift > Security and users: List users in Redshift
Amazon Redshift > Schema naming: List columns by name length in Redshift
Amazon Redshift > Schema naming: Get column name length distribution in Redshift
Amazon Redshift > Schema statistics: Average number of columns per table in Redshift
Amazon Redshift > Schema statistics: List tables with the largest number of columns in Redshift
Amazon Redshift > Schema statistics: Find number of columns in Redshift
Amazon Redshift > Databases and schemas: List user created schemas in Redshift
Amazon Redshift > Databases and schemas: List schemas in Redshift
Snowflake > Session: List sessions / active connections in Snowflake
Snowflake > Constraints: Find required (non nullable) columns in Snowflake
2018-12-14
Query Toolbox
Snowflake > Constraints: Check if is column nullable in Snowflake
Amazon Redshift > Constraints: Find required (non nullable) columns in Redshift
PostgreSQL > Constraints: Find required (non nullable) columns in PostgreSQL database
Amazon Redshift > Constraints: Check if is column nullable in Redshift
PostgreSQL > Default values: Summary of default values in PostgreSQL database
PostgreSQL > Foreign keys: List table columns with their foreign keys in PostgreSQL database
PostgreSQL > Foreign keys: List foreign keys with columns in PostgreSQL database
2018-12-13
Query Toolbox
PostgreSQL > Default values: List table default values in PostgreSQL database
PostgreSQL > Foreign keys: List foreign keys in PostgreSQL database
PostgreSQL > Primary keys: List all primary keys (PKs) and their columns in PostgreSQL database
PostgreSQL > Primary keys: List all primary keys (PKs) in PostgreSQL database
2018-12-12
Query Toolbox
PostgreSQL > Security and users: List users in PostgreSQL database
2018-12-11
Query Toolbox
PostgreSQL > Primary keys: How many tables don't have primary keys (with percentage) in PostgreSQL database
PostgreSQL > Primary keys: Find tables without primary keys (PKs) in PostgreSQL database
PostgreSQL > Primary keys: List tables with their primary keys (PKs) in PostgreSQL database
PostgreSQL > Views: List materialized views in PostgreSQL database
IBM Db2 > Views: List objects used by a view in Db2 database
IBM Db2 > Columns: List all columns in specific table in Db2 database
Amazon Redshift > Databases and schemas: List databases on Redshift instance
2018-12-10
Query Toolbox
Amazon Redshift > Views: List tables used by a view in Redshift
Amazon Redshift > Views: List views columns in Redshift
IBM Db2 > Tables: Find recently created tables in Db2 database
2018-12-07
Query Toolbox
Amazon Redshift > Views: List views in Redshift with their scripts
2018-12-06
Query Toolbox
Amazon Redshift > Columns: List all columns in specific table in Redshift
Amazon Redshift > Columns: List table columns in Redshift
IBM Db2 > Tables: List tables in Db2 database schema
2018-12-05
Query Toolbox
Amazon Redshift > Schema statistics: Find number of tables in Redshift
Amazon Redshift > Tables: List tables in Redshift schema
Amazon Redshift > Tables: List tables in Redshift
Amazon Redshift > Searching schema: Find table that DON'T have a column with specific name in Redshift
Amazon Redshift > Searching schema: Find tables with specific column name in Redshift
2018-12-04
Prev
1
2
3
4
5
6
7
8
Next