Accuracer: The First And Only Cross-Platform BDE Replacement
Client-Server Single-File Embedded Database with SQL for Delphi / C++Builder / Kylix


TACRTable.ExportTableToSQL
TACRTable
Top 

Exports table to SQL script.

function ExportTableToSQL(
ExportStructure:      Boolean = True;
AddDropTableCommand:   Boolean = True;
ExportIndexes:      Boolean = True;
AddDropIndexCommand:   Boolean = False;
ExportData:         Boolean = True;
ExportBLOBFields:      Boolean = True;
UseBracketsForNames:   Boolean = False
): String;

Description

Exports table to SQL script. Returns result SQL script.

ExportStructure determines if table structure should be exported (CREATE TABLE statement).
AddDropTableCommand determines if DROP TABLE command should be added before CREATE TABLE.

ExportIndexes determines if indexes should be exported (CREATE INDEX statement).
AddDropIndexCommand determines if DROP INDEX command should be added before CREATE INDEX.

ExportData determines if records should be exported (INSERT statement).
ExportBLOBFields determines if BLOB fields data should be exported.

UseBracketsForNames determines if table, field and index names should be in square brackets (for special symbols and special names).




© AidAim Software Accuracer: Client-server Database Single-file Database Delphi Database Embedded Databas