My account Book a demo
  • Search
Dataedo Logo
  • Product
      Key Features
    • icon Data Catalog
      Catalog all your data, reports, and collaborate with your data community.
    • icon Data Lineage
      Create a map of your data flow with automated lineage on object and column level.
    • icon Data Quality & Profiling
      Improve data quality and increase trust in your data with data profiling, lineage & more.
    • icon Dataedo AI
      Create auto object descriptions and get help from AI chat in finding tables & writing queries.
    • icon Business Glossary
      Build and share a universal glossary of business terms, policies and rules.
    • icon Data Classification
      Find and tag sensitive data in your databases to comply with data protection regulation.
    • See all features →
      More Features
    • icon Data Community
    • icon Domains
    • icon Reference Data Management
    • icon StewardHub
    • icon Schema Change Tracking
    • icon Workflows
  • Technologies
      Connectors
    • icon SQL Server
    • icon Snowflake
    • icon Power Bi
    • icon Tableau
    • icon Qlik Sense soon
    • icon Databricks
    • icon Microsoft Fabric
    • icon Azure
    • icon AWS
    • icon Oracle
    • All Connectors →
    • Learn More
      • icon Metadata Scanning
  • Solutions
    • By Use Case
      icon Data Governance
    • icon Data Quality
    • icon Selft-Service Analytics
    • icon Data Protection
    • icon Business Intelligence
    • icon Data Warehousing
    • icon Metadata Management
    • All Use Cases →
    • By Industry
      icon Financial Services
    • icon Healthcare
    • icon Public & Government
    • icon Education
    • icon Technology
    • icon Retail
    • icon Energy & Utilities
    • All Industries →
  • Pricing
  • Resources
    • Learn About Dataedo
      icon Documentation
    • icon Roadmap
    • icon Tutorial Videos
    • icon Dataedo Bootcamp
    • icon Downloads
    • Learn About Data
      icon Blog
    • icon Webinars
    • icon Tutorials
    • icon Knowledge Base
    • icon Data Events
    • After Hours
      icon Data Cartoons
    • icon Cartoon Ebooks
  • About us
    • icon About us
    • icon Why Dataedo
    • icon Our Customers
    • icon Our Partners
    • icon Careers
    • icon Contact Us
  • Book a demo
    Try Dataedo
Database Data Dictionary Query Toolbox

Database Query Toolbox

Databases and schemas
  • List databases in popular relational databases
  • List schemas in popular relational databases
  • List user created schemas in popular relational databases
Tables
  • List tables in popular relational databases
  • List tables in specific database schema in popular relational databases
  • Find recently created tables in popular relational databases
  • List tables in all databases on the server in popular relational databases
Columns
  • List table columns in popular relational databases
  • List all columns in specific database table in popular relational databases
Views
  • List views in popular relational databases
  • List views with their scripts in popular relational databases
  • List views columns in popular relational databases
  • List tables used by a view in popular relational databases
Primary keys
  • List all primary keys (PKs) in popular relational databases
  • List all primary keys (PKs) and their columns in popular relational databases
  • List tables with their primary keys (PKs) in popular relational databases
  • Find tables without primary keys (PKs) in popular relational databases
  • How many tables don't have primary keys (with percentage) in popular relational databases
Foreign keys
  • List foreign keys in popular relational databases
  • List foreign keys with columns in popular relational databases
  • List table columns with their foreign keys in popular relational databases
  • List all tables refrenced by specific table (by FK) in popular relational databases
  • List all tables refrencing specific table (by FK) in popular relational databases
  • List tables with most foreign keys in popular relational databases
  • List most referenced tables (by FK) in popular relational databases
  • List tables with most relationships in Vertica database
  • Find tables without foreign keys in popular relational databases
  • Find tables that are not referenced by the foreign keys in popular relational databases
  • Find tables without relationships - Loner Tables - in popular relational databases
  • Loner Ratio - how many tables have no relationships in popular relational databases
Check constraints
  • List all check constraints in popular relational databases
  • List table check constraints in popular relational databases
Default values
  • List table default constraints in popular relational databases
  • Summary of default constraints in popular relational databases
Constraints
  • Find required (non nullable) columns in popular relational databases
  • Check if is column nullable in popular relational databases
Indexes
  • List all indexes in popular relational databases
  • List table indexes in popular relational databases
  • List unique indexes in popular relational databases
Data types
  • Find most used data type in popular relational databases
  • Find large object (LOB) data type columns in popular relational databases
  • Find tables with large object (LOB) data type columns in popular relational databases
Searching database
  • Find databases containing a particular table in popular relational database servers
Searching schema
  • Find a table by name in popular relational databases
  • Find tables with names that contain a specific prefix in popular relational databases
  • Find tables with names that contain a specific suffix in popular relational databases
  • Find tables with specific word in name in popular relational databases
  • Find tables with digits in their names in popular relational databases
  • Find tables with a specific column name in popular relational databases
  • Find tables that DON'T have a column with specific name in popular relational databases
Schema statistics
  • Find number of tables in a database in popular relational databases
  • Find number of columns in a database in popular relational databases
  • List tables with the largest number of columns in popular relational databases
  • Average number of columns per table in popular relational databases
Schema naming
  • Find most popular Find most names in a database in popular relational databases
  • Get column name length distribution in popular relational databases
  • List columns by name length in popular relational databases
Security and users
  • List users in popular relational databases
Session
  • List sessions / active connections in popular relational databases
  • Find last query executed by specific session in popular relational databases
  • Terminate (kill) specific session on popular relational database servers
Environment
  • How to check server version of popular relational databases
  • How to check server edition of popular relational databases
Number of rows
  • List tables by the number of rows in popular relational databases
  • Find empty tables in popular relational databases
Data size
  • List tables by their size in popular relational databases
  • Find database size allocated for LOB data in popular relational databases
Dataedo

Document your data and gather tribal knowledge with Data Dictionary & Data Catalog, Business Glossary, and ERDs.

Contact us
[email protected]
+1 609-849-3393
certificate iso 27001
Cert No. 23513-ISMS-001

Product

  • Features
  • Documentation
  • Roadmap
  • Download
  • Support
  • SQL Analyzer & Paser

Company

  • About us
  • Customers
  • Blog
  • Contact us
  • Careers
  • Partners

Newsletter

Subscribe to our newsletter and receive the latest tips, cartoons & webinars straight to your inbox.

© 2025 Dataedo Sp. z o.o.

Privacy Policy Term of Use License Agreement