Rene Castro – Dataedo

Rene Castro

Database specialist and technical writer

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