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
Free trial
Database Data Dictionary Query Toolbox
Vertica Data Dictionary Query Toolbox
Databases and schemas
List schemas in Vertica database
List user created schemas in Vertica database
Tables
List tables in Vertica database
List tables in Vertica database schema
List projections in Vertica database
Find recently created tables in Vertica database
Columns
List table columns in Vertica database
List all columns in specific table in Vertica database
Views
List views in Vertica database
List views in Vertica database with their scripts
List views columns in Vertica
Primary keys
List all primary keys (PKs) and their columns in Vertica database
Find tables without primary keys (PKs) in Vertica database
How many tables don't have primary keys (with percentage) in Vertica database
Foreign keys
List foreign keys with columns in Vertica database
List table columns with their foreign keys in Vertica database
List all tables refrenced by specific table (by FK) in Vertica database
List all tables refrencing specific table (by FK) in Vertica database
List tables with most foreign keys in Vertica database
List most referenced tables in Vertica database (by FK)
List tables with most relationships in Vertica database
Find tables without foreign keys in Vertica database
Find tables that are not referenced by the foreign keys in Vertica database
Find tables without relationships - Loner Tables - in Vertica database
Loner Ratio - how many tables have no relationships in Vertica database
Unique keys
List unique keys and their columns in Vertica database
Default values
List table default values in Vertica database
Compare default values of different columns with the same name in Vertica database
Summary of default values in Vertica database
Constraints
Check if is column nullable in Vertica database
Data types
Find most used data type in Vertica database
Find all numeric columns in Vertica database
Find all string (character) columns in Vertica database
Find all date and time columns in Vertica database
Functions and stored procedures
List user defined functions (UDFs) in Vertica database
Searching schema
Find a table by the name in Vertica database
Find tables with names with specific prefix in Vertica database
Find tables with names with specific suffix in Vertica database
Find tables with specific word in name in Vertica database
Find tables with digits in names in Vertica database
Find tables with specific column name in Vertica database
Find table that DON'T have a column with specific name in Vertica database
Schema statistics
Find number of tables in Vertica database
Find number of columns in Vertica database
List tables with the largest number of columns in Vertica database
Schema naming
Find most popular column names in Vertica database
Get column name length distribution in Vertica database
List columns by name length in Vertica database
Security and users
List users in Vertica database
List admins in Vertica
Session
Find last query executed by specific user in Vertica
Find queries executed in specific time range in MariaDB database
List sessions / active connections in Vertica database
Find last query executed by specific session in Vertica database
Terminate (kill) specific session in Vertica database
Number of rows
List tables by the number of rows in Vertica
Find empty tables in Vertica database
Number of tables by the number of rows in Vertica database
Data size
List tables by their size in Vertica database
List 10 largest tables in Vertica database
Data usage
Find the time when table was last accessed in Vertica database
Find tables not accessed for past n months in Vertica database
Schema compare
Compare tables and columns in two schemas in Vertica database
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please
accept statistics cookies
.
0
There are no comments.
Click here
to write the first comment.
Please enable JavaScript to view the
comments powered by Disqus.