Get Table name OF Sql Server

AOA
I want to get SQL SERVER Table names in VB6 (In ODBC driver for sql server I pass database name like: Sale)
how can i get all table names in a combobox of database Sale.

thanks & regard

Welcome to the forum!

Check out this thread: http://www.vbforums.com/showthread.p...ght=sysobjects

Personally, I would use the schema views rather than query the system objects. Much easier to use and they are version specific, so changes to the system objects do not affect your code.

Select Table_Name From Information_Schema.Tables Where Table_Type = 'BASE TABLE'