Enum TableOptions
Provides table mapping flags to specify temporary table kind if mapped table is temporary table and Create/Drop Table API behavior when target table exists/not exists.
Namespace: LinqToDB
Assembly: linq2db.dll
Syntax
public enum TableOptions : intFields
| Name | Description |
|---|---|
| CheckExistence | |
| CreateIfNotExists | IF NOT EXISTS option of the CREATE statement. This option will have effect only for databases that support the option. Supported by: DB2, Firebird, Informix, MySql, Oracle, PostgreSQL, SQLite, SQL Server, Sybase ASE. |
| DropIfExists | IF EXISTS option of the DROP statement. This option will have effect only for databases that support the option. Supported by: DB2, Firebird, Informix, MySql, Oracle, PostgreSQL, SQLite, SQL Server, Sybase ASE. |
| IsGlobalTemporaryData | Table data is global temporary (table data is visible from other sessions). This option will have effect only for databases that support temporary tables. Supported by: DB2, Firebird, Oracle, SAP Hana, SQL Server, Sybase ASE. |
| IsGlobalTemporaryStructure | Table is global temporary (table structure is visible from other sessions). This option will have effect only for databases that support temporary tables. Supported by: DB2, Firebird, Oracle, SAP Hana, SQL Server, Sybase ASE. |
| IsLocalTemporaryData | Table data is temporary (table data is not visible to other sessions). This option will have effect only for databases that support temporary tables. Supported by: DB2, Informix, MySql, PostgreSQL, SQLite, SAP Hana, SQL Server, Sybase ASE. |
| IsLocalTemporaryStructure | Table is temporary (table structure is not visible to other sessions). This option will have effect only for databases that support temporary tables. Supported by: DB2, Informix, MySql, PostgreSQL, SQLite, SAP Hana, SQL Server, Sybase ASE. |
| IsTemporary | Table is temporary (not visible to other sessions). This option will have effect only for databases that support temporary tables. If database supports both global and local temporary tables, local table will be used. Supported by: DB2, Firebird, Informix, MySql, Oracle, PostgreSQL, SQLite, SQL Server, SAP Hana, Sybase ASE. |
| IsTemporaryOptionSet | |
| IsTransactionTemporaryData | Table data is temporary (table data is transaction level visible). This option will have effect only for databases that support temporary tables. Supported by: Firebird, Oracle, PostgreSQL. |
| None | |
| NotSet |