Specifies whether or not simple names should be used for tables and columns.

Data Type

bool

Default Value

false

Remarks

FTP tables can include special characters in their names that are typically not allowed in standard databases. This property makes the connector easier to use with traditional database tools.

Setting UseSimpleNames to True simplifies the names of the columns that are returned. It enforces a naming scheme where only alphanumeric characters and underscores are valid for displayed column names.

Notes:

• Any non-alphanumeric characters are converted to underscores.
• If the column or table names exceed 128 characters in length they are truncated to 128 characters to comply with SQL Server standards.