I was wondering if data types in a a literal "create table" statement, executed over ODBC, are replaced with their database specific counterparts (platform is Windows/.Net/C#). I cannot find this feature in the ODBC docs, and there seems to be no list of literal "ODBC data types". However, I know that this works for Oracle, SQL Server and Access; the following statement is executed correctly, although the type LONGVARBINARY is no native type in all of these systems:

CREATE TABLE (MYCOLUMN LONGVARBINARY)

However, e.g. for Oracle the mapped native type depends on the used ODBC driver.

Is this an undocumented feature? Is there a list of supported type names anywhere? Thanks!