TUTI detailed features

TUTI works with any database accessible for BDE:

Paradox, DBase, FoxPro, SQL Server, Interbase, Sybase, Informix, DB2 and Oracle, via fast Borland native drivers.
Microsoft Access via Jet Engine.
Any database compatible with Microsoft ODBC, via vendor-supplied ODBC driver.

Detailed features:

Document detailed schema information of a chosen group of tables and views, including BDE low-level information. This information can be printed or exported to RTF or WRI file. It is a perfect tool to report any database schema. The program shows:

Detailed field's structure.
Detailed index structure.
Number of records.
Table type, language driver, number of validity checks and number of referential integrity checks.
And more...

Document list of stored procedures.
Advanced data transfer between two any tables, optionally creating the destination table (Paradox). The two data structures can be of any type. You can select exactly what records you want to copy (manually and/or filtering), avoid null values in required fields, execute all the process under a general transaction or empty the destination table before the transfer. Transfer models can be saved. The log of process can be viewed and printed. It is a perfect tool to move data between databases and maintaining the integrity between development and real databases. It is useful to fill up tables with large number of records of random values.
Intelligent comparison of tables, searching for schema differences, index differences, extra tables, record count differences and stored procedures differences. The log of process can be viewed and printed. It is a perfect tool to maintaining the integrity between development and real databases.
Delphi code generator to Paradox, DBase or FoxPro table's creation. The code creates tables with all their indexes, exportable to any Delphi project as a standard procedure.
Various functions on a chosen group of tables:

Verify the data and indexes. It warns if it does not exist any index or unique index. It warns if exist table names, field names or index names too long, equal to probable database reserved word or with dangerous characters (useful for detecting future migration problems). It warns if exist indexes with too fields, indexes too big or tables too big. It warns if exist too tables, fields, blob fields, indexes or records. It warns if exist tables or indexes with too fields. It warns if transactions are not supported. It warns if exist read-only tables...
Empty tables.
Delete tables.
Pack Paradox, DBase or FoxPro tables.
Reindex Paradox, DBase or FoxPro tables.
Low-level data verification of Paradox, DBase or FoxPro tables via Inprise Table Maintenance Library (TUtility32).
Low-level reparation of corrupted Paradox tables via Borland Table Maintenance Library (Index is out of date problem, Corrupt table/index header problem, etc.).
Verify number and names of all stored procedures.
View a list of users connected to the same BDE NET DIR.
Chart of number of records.

Automatic generation of a normal SELECT..FROM..ORDER BY statement.
Visual SQL builder.
Generation of live queries.
Transactions.
Filters.
Standard templates.
Autorefresh.
Display memo and image fields directly on the grid.
Blobs exploration, editing, importing, exporting and printing.
Loading, saving or printing of SQL statements.
Automatic form to edit the result.
Perform calculations of numeric statistical functions over entire columns of any data type.
Information of the process.
History of querys.
Bookmarks.
Sequential searches.
Multiselection to delete records.
Print and export the resulting records to a text window, plain text file, CSV, RTF, WRI, DBF, XML or HTML file. All columns has optimized width.
Database tree with drag-and-drop.
Execute querys at a programmatic later time.