ODBC guide

Read all columns of all tables


Gets column metadata for all tables. This operation can be slow.

SELECT * FROM get_table_columns_admin WITH(TableName='*') --requires readonly permissions on sys_dictionary and sys_db_object tables