Vclcomponents - component library for programming languages

Description

Relational Database View takes snapshot of selected databases. After snapshot is taken the database connection is closed and snapshot is used for most of Relational Database ViewCOs functionality. The snapshot can be saved to a file.Relational Database View generates table diagrams using database catalog. Each tableCOs diagram is self-contained and shows logical (primary and foreign keys) and physical (indexes, column attributes) properties of a table. That makes the diagrams easy to follow even for large databases. For example, from the first diagram of titles table you can tell that the table has two indexes Co unique clustered on title_id, and non-unique on title. Column title_id is a primary key, that is referenced in tables roysched, sales and titleauthor. Column pub_id is a foreign key that references pub_id in publishers table. Column title_id is of tid type, which is defined as nvarchar(6).The second diagram shows employee table, that has two indexes, - non-unique clustered on lname, minit, fname (the number inside square show the column number in the index), and unique on epm_id. Column epm_id is primary key, but it is not referenced in any table. Column job_id is a foreign key, that references job_id in jobs table. Column pub_id is another foreign key Co it references pub_id in publishers table.Supported RDBMS: Microsoft SQL Server 6.5 and up, Sybase 9 and up.

Related:

User Reviews:

Related: