On a SQL server DB, I created the following items
create table sample_table( id int identity primary key, value varchar(100));
create view sample_ix_view WITH SCHEMABINDING as select id,value from dbo.sample_table;
create unique clustered index ix_sample_ix_view on dbo.sample_ix_view(id);
I activated ODBC trace log and opened it with Access.
Excerpt from this trace :
MSACCESS 2728-410 ENTER SQLTablesW
...
WCHAR * 0x67DFBBA0 [ -3] "'TABLE','VIEW','SYSTEM TABLE','ALIAS','SYNONYM'\ 0"
...
MSACCESS 2728-410 EXIT SQLTablesW with return code 0 (SQL_SUCCESS)
...
WCHAR * 0x67DFBBA0 [ -3] "'TABLE','VIEW','SYSTEM TABLE','ALIAS','SYNONYM'\ 0"
...
MSACCESS 2728-410 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
...
PTR 0x00717C34 [ 24] "sample_table"
MSACCESS 2728-410 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
...
PTR 0x00717B28 [ 10] "TABLE"
MSACCESS 2728-410 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
...
PTR 0x00717C34 [ 28] "sample_ix_view"
MSACCESS 2728-410 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
...
PTR 0x00717B28 [ 8] "VIEW"
JM.
