Piotr Kononow – Dataedo

Piotr Kononow

CEO, Dataedo

CEO and founder of Dataedo. For many years business analyst, software architect and project manager in various industries - asset management, heavy industry, telco, utilities/gas and tourism. His specialties are data warehousing/BI and business applications.

Query Toolbox

All databases > Searching schema: Find tables that DON'T have a column with specific name in popular relational databases

All databases > Searching schema: Find tables with a specific column name in popular relational databases

All databases > Searching schema: Find tables with digits in their names in popular relational databases

All databases > Searching schema: Find tables with names that contain a specific suffix in popular relational databases

All databases > Searching schema: Find tables with names that contain a specific prefix in popular relational databases

All databases > Searching schema: Find a table by name in popular relational databases

All databases > Primary keys: How many tables don't have primary keys (with percentage) in popular relational databases

All databases > Primary keys: Find tables without primary keys (PKs) in popular relational databases

All databases > Primary keys: List tables with their primary keys (PKs) in popular relational databases

All databases > Primary keys: List all primary keys (PKs) and their columns in popular relational databases

All databases > Primary keys: List all primary keys (PKs) in popular relational databases

All databases > Views: List views with their scripts in popular relational databases

All databases > Columns: List table columns in popular relational databases

All databases > Tables: List tables in all databases on the server in popular relational databases

All databases > Tables: List tables in popular relational databases

2018-10-05

Query Toolbox

All databases > Databases and schemas: List user created schemas in popular relational databases

All databases > Databases and schemas: List schemas in popular relational databases

2018-10-04

Glossary: What is Database Management System (DBMS)

Data Glossary 2018-10-04

Glossary: What is Database Schema

Data Glossary 2018-10-04

Glossary: What is NoSQL (different types)

Data Glossary 2018-10-04

Query Toolbox

All databases > Databases and schemas: List databases in popular relational databases

All databases > Searching schema: Find tables with specific word in name in popular relational databases

2018-10-01

Oracle E-Business Suite > Oracle EBS metadata: Data Dictionary in Oracle e-Business Suite

Application Data Models & Metadata 2018-10-01

Glossary: What is Data Dictionary

Data Glossary 2018-10-01

All databases > Metadata: System Catalog / Data Dictionary Views in relational databases (RDBMS)

Databases - Design & Metadata 2018-09-30

All databases > Metadata: What is INFORMATION_SCHEMA? What databases support it?

Databases - Design & Metadata 2018-09-30

All databases > Metadata: Metadata in relational databases (RDBMS)

Databases - Design & Metadata 2018-09-30

All databases > Metadata: Data Dictionary in relational databases

Databases - Design & Metadata 2018-09-30