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
Get a demo
Free trial
Free trial
Rene Castro
Database specialist and technical writer
Contributors
Rene Castro
Categories
All
KB (22)
Queries (136)
Query Toolbox
MariaDB > Tables: List tables in all databases on MariaDB server
MariaDB > Schema statistics: List tables with the largest number of columns in MariaDB database
MariaDB > Schema statistics: Find number of tables in MariaDB database
2019-01-02
Query Toolbox
MariaDB > Environment: How to check the MariaDB edition
MariaDB > Environment: How to check the MariaDB version
2018-12-17
Query Toolbox
MySQL > Environment: How to check the MySQL edition
MySQL > Environment: How to check the MySQL version
MySQL > Searching database: Find databases containing a particular table in MySQL
MySQL > Primary keys: List all primary keys (PKs) and their columns in MySQL database
MySQL > Primary keys: List all primary keys (PKs) in MySQL database
2018-12-11
Query Toolbox
Azure SQL Database > Data size: Find database size allocated for LOB data in Azure SQL Database
Azure SQL Database > Data size: List tables by their size in Azure SQL Database
Azure SQL Database > Number of rows: Number of tables by the number of rows in Azure SQL Database
Azure SQL Database > Number of rows: Find empty tables in Azure SQL Database
Azure SQL Database > Number of rows: List tables by the number of rows in Azure SQL Database
Azure SQL Database > Environment: How to check the Azure SQL Database version
Azure SQL Database > Session: Terminate (kill) a specific session on a server
Azure SQL Database > Session: Find the last query executed by a specific session in Azure SQL Database
Azure SQL Database > Session: List sessions / active connections in Azure SQL Database
Azure SQL Database > Schema naming: List columns by name length in Azure SQL Database
Azure SQL Database > Schema naming: Get the column name length distribution in Azure SQL Database
Azure SQL Database > Schema naming: Find most popular column names in Azure SQL Database
Azure SQL Database > Schema statistics: Average number of columns per table in Azure SQL Database
Azure SQL Database > Schema statistics: List tables with the largest number of columns in Azure SQL Database
Azure SQL Database > Schema statistics: Find the number of columns in Azure SQL Database
Azure SQL Database > Schema statistics: Find the number of tables in Azure SQL Database
Azure SQL Database > Searching schema: Find tables that DON'T have a column with a specific name in Azure SQL Database
Azure SQL Database > Searching schema: Find tables with a specific column name in Azure SQL Database
Azure SQL Database > Searching schema: Find tables with digits in their names in Azure SQL Database
Azure SQL Database > Searching schema: Find tables with a specific string in the name in Azure SQL Database
Azure SQL Database > Searching schema: Find tables with names that contain a specific suffix in Azure SQL Database
Azure SQL Database > Searching schema: Find tables with names that contain a specific prefix in Azure SQL Database
Azure SQL Database > Searching schema: Find a table by the name in Azure SQL Database
Azure SQL Database > Searching database: Find databases containing a particular table in Azure SQL Database
Azure SQL Database > Data types: Find tables with large object (LOB) data type columns in Azure SQL Database
Azure SQL Database > Data types: Find large object (LOB) data type columns in Azure SQL Database
Azure SQL Database > Data types: Find most used data type in Azure SQL Database
Azure SQL Database > Indexes: List table indexes in Azure SQL Database
Azure SQL Database > Indexes: List all indexes in Azure SQL Database
Azure SQL Database > Constraints: List all table constraints (PK, UK, FK, Check & Default) in Azure SQL Database
Azure SQL Database > Constraints: Find required (non nullable) columns in Azure SQL Database
Azure SQL Database > Default values: List table default constraints in Azure SQL Database
Azure SQL Database > Default values: List all default constraints in Azure SQL Database
Azure SQL Database > Check constraints: List table check constraints in Azure SQL Database
Azure SQL Database > Check constraints: List all check constraints in Azure SQL Database
Azure SQL Database > Indexes: List unique indexes in Azure SQL Database
Azure SQL Database > Unique keys: List unique keys and indexes in Azure SQL Database
Azure SQL Database > Foreign keys: Loner Ratio - how many tables have no relationships in Azure SQL Database
Azure SQL Database > Foreign keys: Find tables without relationships - Loner Tables - in Azure SQL Database
Azure SQL Database > Foreign keys: Find tables that are not referenced by foreign keys in Azure SQL Database
Azure SQL Database > Foreign keys: Find tables without foreign keys in Azure SQL Database
Azure SQL Database > Foreign keys: List tables with most relationships in Azure SQL Database
Azure SQL Database > Foreign keys: List the most referenced tables in a database (by FK) in Azure SQL Database
Azure SQL Database > Foreign keys: List tables with the most foreign keys in Azure SQL Database
Azure SQL Database > Foreign keys: List all tables referencing a specific table (by FK) in Azure SQL Database
Azure SQL Database > Foreign keys: List all tables referenced by a specific table (by FK) in Azure SQL Database
Azure SQL Database > Foreign keys: List table columns with their foreign keys in Azure SQL Database
Azure SQL Database > Foreign keys: List foreign keys with columns in Azure SQL Database
Azure SQL Database > Columns: List table columns in a database
Azure SQL Database > Tables: Identify table types in Azure SQL Database
Azure SQL Database > Primary keys: How many tables don't have primary keys (with percentage)
Azure SQL Database > Primary keys: Find tables without primary keys (PKs)
Azure SQL Database > Primary keys: List tables with their primary keys (PKs)
Azure SQL Database > Primary keys: List all primary keys (PKs) and their columns
Azure SQL Database > Primary keys: List all primary keys (PKs) in a database
MariaDB > Schema naming: Get column name length distribution in MariaDB database
MySQL > Schema naming: Get column name length distribution in MySQL database
MySQL > Schema statistics: Find number of tables in MySQL database
MySQL > Searching schema: Find table that DON'T have a column with specific name in MySQL database
MySQL > Searching schema: Find tables with a specific column name in MySQL database
MySQL > Views: List views in MySQL with their scripts
MySQL > Databases and schemas: List databases (schemas) on MySQL server
MariaDB > Databases and schemas: List databases (schemas) on MariaDB instance
Azure SQL Database > Databases and schemas: List databases in Azure SQL Database
2018-12-10
Query Toolbox
Azure SQL Database > Databases and schemas: List schemas in Azure SQL Database
2018-10-06
Query Toolbox
Azure SQL Database > Tables: List tables in Azure SQL Database
Azure SQL Database > Databases and schemas: List user created schemas in Azure SQL Database
2018-10-05
Query Toolbox
MySQL > Columns: List table columns in MySQL database
MySQL > Tables: List tables from all databases in MySQL
MySQL > Tables: List tables in MySQL database
2018-10-04
Query Toolbox
MySQL > Schema statistics: List tables with the largest number of columns in MySQL database
2018-08-17
Query Toolbox
MariaDB > Searching schema: Find a table by name in MariaDB database
MariaDB > Searching schema: Find tables with names that contain a specific suffix in MariaDB database
MariaDB > Searching schema: Find tables with digits in their names in MariaDB database
MariaDB > Searching schema: Find tables with a specific column name in MariaDB database
MariaDB > Searching schema: Find table that DON'T have a column with specific name in MariaDB database
MariaDB > Searching schema: Find tables with a specific string in the name in MariaDB database
MariaDB > Searching schema: Find tables with names that contain a specific prefix in MariaDB database
MariaDB > Views: List views in MariaDB database with their scripts
MariaDB > Tables: List tables in MariaDB database
2018-08-09
Query Toolbox
MySQL > Searching schema: Find tables with a specific string in the name in MySQL database
MySQL > Searching schema: Find tables with names that contain a specific suffix in MySQL database
MySQL > Searching schema: Find tables with names that contain a specific prefix in MySQL database
MySQL > Searching schema: Find tables with digits in their names in MySQL database
MySQL > Searching schema: Find a table by name in MySQL database
2018-07-23
Prev
1
2
Azure SQL Database > Searching schema: Find tables with a specific column name in Azure SQL Database
All Use Cases
