Importing and Exporting Data

The into, save as and to clauses supported by the SQL select statement offer a wide range of export formats for the selected rows.

select <column-definition> from <table-definition> to file <filename>

Examples

select * from shippers to file shiptxt

select <column-definition> from <table-definition> into xml <xml filename>

or

select <column-definition> from <table-definition> save as xml <xml filename>

Examples

select employeeid, lastname, firstname from employees save as xml emp

select <column-definition> from <table-definition> into html <html filename>

select <column-definition> from <table-definition> into json <filename>

Contents