https://bugs.documentfoundation.org/show_bug.cgi?id=130564
--- Comment #10 from Lionel Elie Mamane <[email protected]> --- Call SQLGetInfo(handle, SQL_CREATE_VIEW, &result, ...) Assuming a "good" ODBC driver, the database supports views if and only if (result & SQL_CV_CREATE_VIEW) to test whether the database supports creations of views. Documentation from https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqlgetinfo-function An SQLUINTEGER bitmask enumerating the clauses in the CREATE VIEW statement, as defined in SQL-92, supported by the data source. The following bitmasks are used to determine which clauses are supported: SQL_CV_CREATE_VIEW SQL_CV_CHECK_OPTION SQL_CV_CASCADED SQL_CV_LOCAL A return value of "0" means that the CREATE VIEW statement is not supported. An SQL-92 Entry level-conformant driver will always return the SQL_CV_CREATE_VIEW and SQL_CV_CHECK_OPTION options as supported. An SQL-92 Full level-conformant driver will always return all of these options as supported. -- You are receiving this mail because: You are the assignee for the bug.
