Text file created by exporting a table from a Windows Installer database; contains the ASCII text representation of the relational data stored in the table; used for reviewing database information in a human-readable format; also used for committing the text version of a table to a source code control system. IDT files can be exported using the MsiDatabaseExport function, which is part of the Windows Installer API. IDT files can also be imported into an existing database using the MsiDatabaseImport function. A Windows Installer databases contains the data required to install a group of applications. The databases can be customized using third-party applications and relational queries, which helps tailor the installation data for specific needs.
The IDT file extension is associated with Microsoft Windows Installer and used for files in so called Text Archive Format. When an entire database is exported to archive files, each table in the database has a separate .idt file. If a table contains a stream column, each stream in the table is represented by a file with an IBD file extension. A .idt file of an exported database table that contains only ASCII characters has the following basic format. The first row contains the table column names separated by tabs. The second row contains the column definitions separated by tabs. If the file contain only ASCII data, the third row is table name and primary key column names separated by tabs. The remaining rows in the file represent rows in the table, with columns separated by tabs. If the file contains non-ASCII data, the basic archive file format of the .idt file is extended to include code page information. The third row in the .idt table is the numeric code page followed by the table name and primary key column names separated by tabs.