Sybase ASE 15 temporary tables are not supported

Namespace: NHibernate.Dialect
Assembly: NHibernate (in NHibernate.dll) Version: 3.2.0.4000 (3.2.0.4000)

Syntax

C#
public override bool SupportsTemporaryTables { get; }
Visual Basic
Public Overrides ReadOnly Property SupportsTemporaryTables As Boolean
	Get
Visual C++
public:
virtual property bool SupportsTemporaryTables {
	bool get () override;
}

Remarks

By default, temporary tables in Sybase ASE 15 can only be created outside a transaction. This is not supported by NHibernate. Temporary tables (and other DDL) statements can only be run in a transaction if the 'ddl in tran' database option on tempdb is set to 'true'. However, Sybase does not recommend this setting due to the performance impact arising from locking and contention on tempdb system tables.

See Also