SqlScriptSaveOptions

sqlScriptSaveOptions

Represents the options of saving .sql file.

Property Name Property Type Nullable ReadOnly DefaultValue Description
CheckIfTableExists Boolean True False Check if the table name exists before creating
ColumnTypeMap String True False Gets and sets the map of column type for different database.
CheckAllDataForColumnType Boolean True False Check all data to find columns' data type.
AddBlankLineBetweenRows Boolean True False Insert blank line between each data.
Separator String True False Gets and sets character separator of sql script.
OperatorType String True False Gets and sets the operator type of sql.
PrimaryKey Integer True False Represents which column is primary key of the data table.
CreateTable Boolean True False Indicates whether exporting sql of creating table.
IdName String True False Gets and sets the name of id column.
StartId Integer True False Gets and sets the start id.
TableName String True False Gets and sets the table name.
ExportAsString Boolean True False Indicates whether exporting all data as string value.
ExportArea Class:CellArea True False Gets or sets the exporting range.
HasHeaderRow Boolean True False Indicates whether the range contains header row.
SaveFormat String True False
CachedFileFolder String True False
ClearData Boolean True False
CreateDirectory Boolean True False
EnableHTTPCompression Boolean True False
RefreshChartCache Boolean True False
SortNames Boolean True False
ValidateMergedAreas Boolean True False

Parent Name : SaveOptions