sales@dataedo.com
+1 704-387-5078
My account
Search
product
Data Catalog
Data Community
Business Glossary
Data Profiling
Data Dictionary
Database Documentation
Database Change Tracking
Data Discovery
ER Diagrams
Metadata Scanners
See All...
Solutions
By Use Case
Business Intelligence
Data Warehousing
Data Governance
Data Protection
Metadata Management
Data Lakes
Database Development
Development Outsourcing
Self-service BI
See All...
Pricing
Case Studies
Resources
General
Blog
Webinars
Videos
Data Knowledge Base
Library
Cartoon
Dataedo
Documentation
Tutorials
Samples
Support
Contact support
Support forum
Documentation
Tutorials
Get a demo
Get a demo
Free trial
Free trial
Bart Gawrych
Database developer
Contributors
Bart Gawrych
Categories
All
KB (36)
Queries (538)
Query Toolbox
Azure SQL Database > Functions and stored procedures: List user defined functions (UDFs) in Azure SQL databsae
SQL Server > Functions and stored procedures: List user defined functions (UDFs) in SQL Server databsae
2019-03-04
Query Toolbox
SQL Server > Views: List indexed (materialized) views in SQL Server database
2019-02-27
Query Toolbox
IBM Db2 > Data types: Find all XML data columns in Db2 database
IBM Db2 > Data types: Find all date and time columns in Db2 database
IBM Db2 > Data types: Find all string columns in Db2 database
IBM Db2 > Data types: Find all numeric columns in Db2 database
2019-02-26
Query Toolbox
Amazon Redshift > Session: List sessions / active connections in Redshift
2019-02-25
Query Toolbox
MariaDB > Environment: How to find operating system (OS) that MariaDB database runs on
MySQL > Environment: How to find operating system (OS) that MySQL database runs on
MySQL > Dependencies: Find where specific function is used in MySQL database
MariaDB > Data types: Find most used data type in MySQL database
MariaDB > Columns: List all columns in specific table in MariaDB database
MariaDB > Columns: List all computed columns in MariaDB database
MySQL > Columns: List all computed (generated) columns in MySQL database
Azure SQL Database > Data size: List 10 largest tables in Azure SQL database
SQL Server > Data size: List 10 largest tables in SQL Server
Azure SQL Database > Dependencies: Find tables that are not used by any other object in Azure SQL database
SQL Server > Dependencies: Find tables that are not used by any other object in SQL Server database
Azure SQL Database > Dependencies: Find objects used by specific stored procedure in Azure SQL database
Azure SQL Database > Dependencies: Find objects used by specific function in Azure SQL database
SQL Server > Dependencies: Find objects used by specific stored procedure in SQL Server database
SQL Server > Dependencies: Find objects used by specific function in SQL Server database
Azure SQL Database > Tables: List tables in Azure SQL schema
SQL Server > Tables: List tables in SQL Server schema
2019-02-18
Query Toolbox
Azure SQL Database > Data types: Find all string (character) columns in Azure SQL database
SQL Server > Data types: Find all string and binary columns in SQL Server database
2019-02-14
Query Toolbox
SQL Server > Views: List tables used by a view in SQL Server
Azure SQL Database > Tables: Find recently modified tables in Azure SQL database
Azure SQL Database > Tables: Find recently created tables in Azure SQL database
Azure SQL Database > Tables: List graph tables in Azure SQL database
SQL Server > Environment: How to find operating system (OS) that SQL Server runs on
Azure SQL Database > Data types: Find all spatial data columns in Azure SQL database
SQL Server > Data types: Find all spatial data columns in SQL Server database
Azure SQL Database > Columns: List all computed columns in Azure SQL database
SQL Server > Columns: List all computed columns in SQL Server database
SQL Server > Tables: List tables in all databases in SQL Server instance
2019-02-11
Query Toolbox
Azure SQL Database > Views: List views columns in Azure SQL
Azure SQL Database > Views: List views in Azure SQL database with their scripts
Azure SQL Database > Views: List views in Azure SQL database
Azure SQL Database > Columns: List all columns in specific table in Azure SQL database
Azure SQL Database > Tables: List all table names in particular schema in Azure SQL Database
Azure SQL Database > Data types: Find all date and time columns in Azure SQL database
SQL Server > Data types: Find all date and time columns in SQL Server database
Azure SQL Database > Data types: Find all numeric columns in Azure SQL database
SQL Server > Data types: Find all numeric columns in SQL Server database
2019-02-08
Query Toolbox
MariaDB > Check constraints: List all check constraints in MariaDB database
MariaDB > Check constraints: List table check constraints in MariaDB database
SQL Server > Views: List views columns in SQL Server
SQL Server > Views: List views in SQL Server with their scripts
2019-02-06
Query Toolbox
IBM Db2 > Data size: List tables by the size of their indexes in Db2 database
IBM Db2 > Data size: List idexes by their size in Db2 database
Oracle database > Check constraints: List table check constraints in Oracle database
Oracle database > Check constraints: List all check constraints on tables in Oracle database
MariaDB > Schema naming: Find most popular column names in MariaDB database
MySQL > Schema naming: Find most popular column names in MySQL database
MariaDB > Tables: Identify table storage engine in MariaDB database (schema)
MySQL > Tables: Identify table storage engine in MySQL database (schema)
SQL Server > Constraints: Check if is column nullable in SQL Server database
SQL Server > Views: List views in SQL Server database
SQL Server > Tables: Find recently modified tables in SQL Server database
SQL Server > Tables: Find recently created tables in SQL Server database
SQL Server > Tables: List all table names in particular schema in SQL Server
2019-02-05
Query Toolbox
Oracle database > Primary keys: Find tables without primary keys (PKs) in Oracle database
Oracle database > Primary keys: List tables with their primary keys (PKs) in Oracle database
Oracle database > Primary keys: List all primary keys (PKs) in Oracle database
MySQL > Foreign keys: Loner Ratio - How many tables do not have relationships in MySQL database
MariaDB > Foreign keys: Loner Ratio - How many tables do not have relationships in MariaDB database
MySQL > Foreign keys: Find tables without relationships - Loner Tables - in MySQL database
MariaDB > Foreign keys: Find tables without foreign keys in MariaDB database
MySQL > Foreign keys: Find tables without foreign keys in MySQL database
IBM Db2 > Data size: Find database size allocated for LOB data in Db2 database
MySQL > Foreign keys: List tables with most relationships in MySQL database
MySQL > Tables: Find recently modified tables in MySQL database
MariaDB > Tables: Find recently modified tables in MariaDB database
MariaDB > Data types: Find all spatial data columns in MariaDB database
MySQL > Data types: Find all spatial data columns in MySQL database
MySQL > Functions and stored procedures: List stored procedure parameters in MySQL database
MariaDB > Functions and stored procedures: List stored procedure parameters in MariaDB database
MariaDB > Functions and stored procedures: List stored procedures and functions in MariaDB database
MySQL > Functions and stored procedures: List stored procedures and functions in MySQL database
2019-02-04
Query Toolbox
Snowflake > Functions and stored procedures: List user defined functions (UDFs) in Snowflake
IBM Db2 > Security and users: List users in Db2 database
2019-01-30
Prev
1
2
3
4
5
6
7
8
Next
