My account
Book a demo
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
Free trial
Download
Support
Contact support
Documentation
Tutorials
Free trial
Product tour
Database Data Dictionary Query Toolbox
Azure SQL Database Data Dictionary Query Toolbox
Databases and schemas
List databases in Azure SQL Database
List schemas in Azure SQL Database
List user created schemas in Azure SQL Database
Tables
List tables in Azure SQL Database
List all table names in particular schema in Azure SQL Database
List tables in Azure SQL schema
List temporal tables in Azure SQL database
List graph tables in Azure SQL database
Identify table types in Azure SQL Database
Find recently created tables in Azure SQL database
Find recently modified tables in Azure SQL database
Columns
List table columns in a database
List all columns in specific table in Azure SQL database
List all computed columns in Azure SQL database
Views
List views in Azure SQL database
List views in Azure SQL database with their scripts
List views columns in Azure SQL
List tables used by a view in Azure SQL database
List indexed (materialized) views in Azure SQL database
Primary keys
List all primary keys (PKs) in a database
List all primary keys (PKs) and their columns
List tables with their primary keys (PKs)
Find tables without primary keys (PKs)
How many tables don't have primary keys (with percentage)
Foreign keys
List foreign keys in Azure SQL Database
List foreign keys with columns in Azure SQL Database
List table columns with their foreign keys in Azure SQL Database
List all tables referenced by a specific table (by FK) in Azure SQL Database
List all tables referencing a specific table (by FK) in Azure SQL Database
List tables with the most foreign keys in Azure SQL Database
List the most referenced tables in a database (by FK) in Azure SQL Database
List tables with most relationships in Azure SQL Database
Find tables without foreign keys in Azure SQL Database
Find tables that are not referenced by foreign keys in Azure SQL Database
Find tables without relationships - Loner Tables - in Azure SQL Database
Loner Ratio - how many tables have no relationships in Azure SQL Database
Unique keys
List unique keys and indexes in Azure SQL Database
Check constraints
List all check constraints in Azure SQL Database
List table check constraints in Azure SQL Database
Default values
List all default constraints in Azure SQL Database
List table default constraints in Azure SQL Database
Summary of default constraints in Azure SQL database
Constraints
List all table constraints (PK, UK, FK, Check & Default) in Azure SQL Database
Find required (non nullable) columns in Azure SQL Database
Check if is column nullable in Azure SQL database
Indexes
List all indexes in Azure SQL Database
List table indexes in Azure SQL Database
List unique indexes in Azure SQL Database
Data types
Find most used data type in Azure SQL Database
Find all numeric columns in Azure SQL database
Find all string (character) columns in Azure SQL database
Find all date and time columns in Azure SQL database
Find all spatial data columns in Azure SQL database
Find all XML data columns in Azure SQL database
Find large object (LOB) data type columns in Azure SQL Database
Find tables with large object (LOB) data type columns in Azure SQL Database
Triggers
List triggers in Azure SQL database
List table triggers in Azure SQL database
Functions and stored procedures
List user defined functions (UDFs) in Azure SQL databsae
List stored procedures in Azure SQL database
Dependencies
List objects that use specific object in Azure SQL database
Find objects used by specific function in Azure SQL database
Find objects used by specific stored procedure in Azure SQL database
Find where specific table or view is used in Azure SQL Database
Find where specific function is used in Azure SQL database
Find where specific stored procedure is used in Azure SQL database
Find tables that are not used by any other object in Azure SQL database
List tables used by Indexed (Materialized) Views
Searching database
Find databases containing a particular table in Azure SQL Database
Searching schema
Find a table by the name in Azure SQL Database
Find tables with names that contain a specific prefix in Azure SQL Database
Find tables with names that contain a specific suffix in Azure SQL Database
Find tables with a specific string in the name in Azure SQL Database
Find tables with digits in their names in Azure SQL Database
Find tables with a specific column name in Azure SQL Database
Find tables that DON'T have a column with a specific name in Azure SQL Database
Schema statistics
Find the number of tables in Azure SQL Database
Find the number of columns in Azure SQL Database
List tables with the largest number of columns in Azure SQL Database
Average number of columns per table in Azure SQL Database
Schema naming
Find most popular column names in Azure SQL Database
Get the column name length distribution in Azure SQL Database
List columns by name length in Azure SQL Database
Security and users
List users in Azure SQL database
Session
List sessions / active connections in Azure SQL Database
Find the last query executed by a specific session in Azure SQL Database
Terminate (kill) a specific session on a server
Environment
How to check the Azure SQL Database version
How to check the Azure SQL Database edition
Number of rows
List tables by the number of rows in Azure SQL Database
Find empty tables in Azure SQL Database
Number of tables by the number of rows in Azure SQL Database
Data size
List tables by their size in Azure SQL Database
List idexes by their size in Azure SQL
List tables by the size of their indexes in Azure SQL
List 10 largest tables in Azure SQL database
Find database size allocated for LOB data in Azure SQL Database
Schema compare
Compare tables and columns in two schemas in Azure SQL schemas
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.
All Use Cases
