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
PostgreSQL > Session: Find last query executed by specific session in PostgreSQL database
MariaDB > Jobs/events: List events on MariaDB server
MySQL > Jobs/events: List events on MySQL server
2019-01-29
Query Toolbox
MariaDB > Unique keys: List unique keys and indexes in MariaDB database
MySQL > Unique keys: List unique keys and indexes in MySQL database
MySQL > Data types: Find all JSON data columns in MySQL database
MySQL > Data types: Find all enum columns in MySQL database
MariaDB > Data types: Find all enum columns in MySQL database
MariaDB > Data types: Find all numeric columns in MariaDB database
MySQL > Data types: Find all numeric columns in MySQL database
MySQL > Data types: Find all date and time columns in MySQL database
MariaDB > Data types: Find all date and time columns in MariaDB database
MariaDB > Data types: Find all string (character) columns in MariaDB database
MySQL > Data types: Find all string (character) columns in MySQL database
MariaDB > Indexes: List unique indexes in MariaDB database
MySQL > Indexes: List unique indexes in MySQL database
MySQL > Data size: List idexes by their size in MySQL database
MariaDB > Data size: List idexes by their size in MariaDB database
2019-01-28
Query Toolbox
MariaDB > Tables: List InnoDB tables in MySQL database
MySQL > Tables: List InnoDB tables in MySQL database
MySQL > Tables: List MyISAM tables in MySQL database
MariaDB > Tables: List MyISAM tables in MariaDB database
MySQL > Data size: List tables by the size of data and indexes in MySQL database
MariaDB > Data size: List tables by the size of their indexes in MariaDB database
MySQL > Data size: List tables by the size of their indexes in MySQL database
MariaDB > Data size: List 10 largest tables in MariaDB database
MySQL > Data size: List 10 largest tables in MySQL database
2019-01-25
Query Toolbox
MariaDB > Default values: List table default values in MariaDB database
MySQL > Default values: List table default values in MySQL database
MariaDB > Default values: List all default values in MariaDB database
MySQL > Default values: List all default values in MySQL database
2019-01-24
Query Toolbox
MariaDB > Default values: Summary of default values in MariaDB database
MySQL > Default values: Summary of default values in MySQL database
MySQL > Indexes: List table indexes in MySQL database
MariaDB > Indexes: List table indexes in MariaDB database
MariaDB > Indexes: List all indexes in MariaDB database
MySQL > Indexes: List all indexes in MySQL database
MariaDB > Triggers: List triggers by table name in MariaDB database
MySQL > Number of rows: Number of tables by the number of rows in MySQL database
MySQL > Session: Terminate (kill) a specific session on MySQL server
MariaDB > Constraints: Find required (non nullable) columns in MariaDB database
MariaDB > Constraints: Check if is column nullable in MariaDB database
MariaDB > Triggers: List triggers in MariaDB database
2019-01-21
Query Toolbox
MariaDB > Primary keys: List all primary keys (PKs) and their columns in MariaDB database
MariaDB > Views: List views columns in MariaDB database
MariaDB > Views: List views in MariaDB database
MariaDB > Tables: Find recently created tables in MariaDB database
MySQL > Tables: Find recently created tables in MySQL database
MariaDB > Databases and schemas: List user created databases (schemas) in MariaDB
MariaDB > Security and users: List users in MariaDB database
MySQL > Security and users: List users in MySQL database
MariaDB > Foreign keys: List table columns with their foreign keys in MariaDB database
MySQL > Foreign keys: List table columns with their foreign keys in MySQL database
MariaDB > Foreign keys: List foreign keys with columns in MariaDB database
MySQL > Foreign keys: List foreign keys with columns in MySQL database
MariaDB > Foreign keys: List foreign keys in MariaDB database
MySQL > Foreign keys: List foreign keys in MySQL database
2019-01-18
Query Toolbox
MySQL > Triggers: List triggers by table name in MySQL database
MySQL > Triggers: List triggers in MySQL database
MySQL > Constraints: Find required (non nullable) columns in MySQL database
MariaDB > Primary keys: How many tables don't have primary keys (with percentage) in MariaDB database
Snowflake > Data usage: Find unused tables in Snowflake
IBM Db2 > Data usage: Find tables not accessed for past n months in Db2 database
IBM Db2 > Data usage: Find the time when table was last accessed in Db2 database
MySQL > Constraints: Check if is column nullable in MySQL database
MySQL > Primary keys: How many tables don't have primary keys (with percentage) in MySQL database
MySQL > Views: List tables used by a view in MySQL database
MySQL > Views: List views columns in MySQL database
MySQL > Views: List views in MySQL database
2019-01-17
Query Toolbox
Teradata > Searching database: Find databases containing a particular table on Teradata server
MySQL > Primary keys: Find tables without primary keys (PKs) in MySQL database
MariaDB > Primary keys: Find tables without primary keys (PKs) in MariaDB database
MariaDB > Primary keys: List tables with their primary keys (PKs) in MariaDB database
MySQL > Primary keys: List tables with their primary keys (PKs) in MySQL database
MySQL > Databases and schemas: List user created databases (schemas) in MySQL
MySQL > Columns: List all columns in specific table in MySQL database
Teradata > Tables: Find recently created tables in Teradata database
2019-01-15
Query Toolbox
MySQL > Session: Find last query executed by specific session on MySQL server
IBM Db2 > Data size: List tables by their size in Db2 database
2019-01-14
Query Toolbox
Snowflake > Session: Abort (kill) specific session on a server
Snowflake > Session: Find queries executed in specific warehouse in Snowflake
Snowflake > Session: Find queries executed in specific time range in Snowflake
Snowflake > Session: Find last query executed by specific user in Snowflake
Snowflake > Session: Find last query executed by specific session in Snowflake
2019-01-03
Query Toolbox
MariaDB > Primary keys: List all primary keys (PKs) in MariaDB database
2019-01-02
Query Toolbox
Teradata > Views: List views in Teradata database
PostgreSQL > Session: List sessions / active connections in PostgreSQL database
Amazon Redshift > Default values: List table default values in Redshift
Amazon Redshift > Schema naming: Find most popular column names in Redshift
2018-12-21
Prev
1
2
3
4
5
6
7
8
Next