Schema Files

<< Click to Display Table of Contents >>

Navigation:  Menus > Export > Grid Contents to CSV >

Schema Files

Previous pageReturn to chapter overviewNext page

Schema Files (*.sch)

Table structure for csv/text files via Schema file

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:


... etc.

as for example:


"FLOAT";"0";"Species No"



"VARCHAR";"40";"Species Name"

"WORD";"0";"Length (cm)"

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.

Text Export: Schema File

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 and other DBMS (Data Base Management Systems)

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.

Please see also menu File \ Import \ From Delimited Text File.
Please see also menu Export \ Grid Contents to CSV ...

AbsoluteSQL Application Manual - 24 November 2023 - Copyright © 2011 - 2023 Niels Knabe