ODBC and tables 'v' views

Hi Folks

Sorry if you've seen this, but I did not receive a copy.

(This is under WinXP, with a DSN pointing to an MS Access db).

Is there an ODBC function call, or anything, which will distinguish between
tables and views?

I looked at DBI::Const::GetInfo::ODBC, and tried $dbh -> get_info(19) for
SQL_ACCESSIBLE_TABLES and -> get_info(149) for SQL_INFO_SCHEMA_VIEWS
but they returned 0 and 'Y' (I think - I'm at home now) respectively.

--
Cheers
Ron Savage, ron@xxxxxxxxxxxxx on 23/06/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company


.

Relevant Pages