>Dear friends,
>
>How can I know that how many tables contain in the Database on SQL Server? Can I retrieve the name of table? Thank you for your help ....
>
>Best Regards,
>
>Justy Chow

To do it with ADO, check out this UT download: http://www.levelextreme.com/wconnect/wc.dll?FournierTransformation~2,54,Forum=5,28,1454

Particularly the testmyrs.prg program. Use the SQL Server connection string and just change the server name to yours.