how to count how many table in database at runtime in visual basic 6.0

[jimmylee]

Hi all,

I'd like to know how many table in sql database or Access database at runtime in visual basic 6.0
thanks,

[debasisdas]

try to use this

"select name,id from sysobjects where xtype='U'"

connect to master database for this.

[jimmylee]

I mean not sql statment.

how many tables in sql datase. how to code in visual basic.

[debasisdas]

The query in previous post returns all the tables .

You can use COUNT() on that for the number of tables.