[RESOLVED] [2005] How to listout databases and table names?

How to list out databases and table names of a particular user id through coding?

Once you have established a connection to the sql server , use the following commands
sp_databases
sp_tables

thanks

You can also use the GetSchema method of your connection object.