The application is dedicated to IT analysts, consultants, database specialists, SQL developers, and programmers especially when they need to

⏵ get orientation in new database (or poor documented) database by visualization table relations with their constaints, as well as
whole referencing hierarchy of selected table (so what tables refer to the selected table, and where the selected table refers to),
⏵ get list of locations where, some table (or other database object) is used (in whole database),
⏵ get advanced profile of selected table (indexes, contraints, duplicities, and other info), or create an advanced data filter upon selected table,
⏵ create complex SQL SELECT commands in visual way by mouse clicks, with special JOIN conditions editor (i.e. datatype compatibility
highlighting, and more).


If you have to work with new/large SQL Server database, the application should help you if you want to:

✅ Search for value in all database tables and database object definitions,

- when you want to get all table names, columns, and records where some value is stored,
- when you want to get list of database objects names and definitions (stored procedures, triggers, functions, and views) where searched
value appears,
- when you want to determine places where modifications in certain database object can cause unwanted impacts to tables and other database
objects.


✅ Check the relationships based on constraints between database tables, whole relationship hierarchy, and localize the database objects (stored procedures, triggers, functions, and views) in which the table is used,

- if you need a list (or whole hierarchy) of related tables who refer to the selected table,
- if you need a list (or whole hierarchy) of related tables to which the selected table refers,

(useful by SELECT command building, or when you want to check the place(s) that may cause some problems regarding data integrity and
consistence, or if you want to make some changes in certain table and you want to know the places where future changes will have impact).


✅ Build a SQL SELECT command using visual designer (or builder), where you can see related tables (what refers to the selected table and where the selected table refers to) which can be useful by joining the multiple tables, or if you have to create advanced data filtering, and others.


✅ Browse for table data, check for table columns, indexes, constrains, get table information, and other, i.e.:
- if you need to check column data types and table indexes by SELECT command building,
- if you need to check table constraints by INSERT and UPDATE command building,
- if you need to quick browse and search in table data,
- if you need to get some statistics about the selected table like count of rows, size in [MB], creation date, ...
- if you need to get list of tables used in selected view.


IMPORTANT NOTES:

● The application is dedicated to Microsoft SQL Server only.

● Target architecture for installing: x86, x64

● Available versions:
1.) NON-COMMERCIAL use only (turns off after 15min since launch, then restart is needed). Free.
2.) COMMERCIAL USE. Paid.
Both of them are full featured.

● The application was tested on large database with 2000+ tables.