connect to MS SQL Server via ODBC

[Robert Eppich]

Hello All,

I am trying to get a list of the table names from an SQL Server. By  
using the following script:

put RevDataFromQuery("","",line 1 of fld 1,"select name from  
sys.tables")

These tablenames are returned.

spt_fallback_db
spt_fallback_dev
spt_fallback_usg
spt_monitor
spt_values

However, this is not what I expected to see. It seems as though the  
tables are one level deeper in "dbo" and then "Tables", at least this  
is how Crystal Reports displays it.

I'm looking for a specific table called "Labor_Ticket". I have used  
the "Database Query Builder" tool in Rev and the tables listed are  
the same. How do I get another level deeper to the actual tables I'm  
looking for.

Thanks for any ideas.
Rob