need help...... [modified]

[d24k104d]

is there a way to know the number of tables in an sql database without opening sql enterprise manager/configuration? using vb.net 2005 application a simple codes/explanation will help thanks...:-D -- modified at 4:04 Monday 3rd July, 2006

[soodmonu]

You can find this information from sysobjects table. All the user defined table having the type 'U' So writing a query like this will give u number of tables in a database select count(*) from sysobjects where type = 'U' NOTE :- Check for the table named "dtProperties", it is a system defined table but type is "U" only (so whatever the count comes COUNT-1 will give u exact number), no idea why, if anyone know about this then please clear my doubt regarding this table. :)

[d24k104d]

thanks this will help... ill try this one.... thank you again...:cool: