I apologize for being new to SQL. I appreciate all the help I can get.

I need to see all of the tables in a database. I am running Microsoft SQL Server 2000, but I don't have a GUI. It's all command line.

What shall I use to display the tables in a database?

Thank you in advance for your help.

Regards,

Hector

Is there a GUI client that I can use to connect to the database on my Microsoft SQL Server 2000?

A third party app?

Thank you in advance for your help.

Regards,

Hector

Hi Hector,

If you do a google search for 'mssql manager software' you will get several choices.

Thank you. I will do that.

Where can I find Enterprise Manager snap-in? It's not anywhere on my system. I've even checked the console but it was not listed there either.

run

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQL Server Enterprise Manager.MSC

u can all so view all table name in sysobjects(command line)

select * from sysobjects where xtype ='U'