Text export by AbsoluteSQL is always followed by a descriptive schema file specifying the data types and field sizes to be specified when reimporting the exported text files.
The schema file itself is a semicolon delimited text file named as the exported data file and with the .sch extension and of the structure:
as for example:
Though the field types SHORTINT, BYTE and EXTENDED in the schema file are tagged as SMALLINT, WORD and FLOAT, the original data types SHORTINT, BYTE and EXTENDED will still be accepted and used from the schema file, which thus may be edited to comply this if desired. However, the wider 16-bit data types SMALLINT and WORD are often preferred even if not strictly needed.
When exporting to data to text files (*.csv, *.txt or *.tab) the autogeneration of associated schema file (*.sch) is optional,
- see Export menu.
Schema files per se is not a standard, however the structure is often easily read, and either used by reading the contents for manual use or easily modifying the Schema file to comply with automated data structuring by the importing application.