How to determine ODBC supported join operators - Cross Join <p>Given an ODBC connection string, I'm trying to determine whether this connection supports cross joining.</p> <p>Currently I use the following code to determine the supported join operators:</p> <pre><code>(SupportedJoinOperators)connection.GetSchema("DataSourceInformation").Rows[0]["SupportedJoinOperators"] </code></pre> <p>But this only gives me Inner, Left, Right and Full joins. </p> <p>For example, if a connection string uses the <em>microsoft text driver (</em>.txt <em>.csv)</em>, the supported join operators are left and right, and the driver actually doesn't support the cross join operator (fails with a message of incorrect syntax).</p> <p>Using workarounds doesn't guarantee a correct answer, as I gather from <a href="http://blog.jooq.org/2014/02/12/no-cross-join-in-ms-access/" rel="nofollow">this</a> link.</p> <p>I also thought of trying a lower level, like using Pinvoke with the ODBC API like <code>SqlGetInfo</code> or <code>SqlGetFunctions</code> but it seems like a dead end.</p> <p>Any help will be greatly appreciated!</p>