I have MSDE loaded on my computer and have a database that I want to
query but don't know what tables are in the database (an ASP.net
learning program created the database). How do I get information about
the tables in the database? Do I use 'osql' from a command line?

Thanks,
RABMissouri

Hi !

You can use OSQL or a graphical user interface which can be downloaded
from the internet, here are some samples of free GUIs:

http://www.aspfaq.com/2442

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Thanks,

If I were using OSQL, what would be the transact statement to find out
what tables are in a database?

RABMissouri

when I ran that script I got the following error

msg 208...
invalid object name 'INFORMATION_SCHEMA'.

Thanks,
RABMissouri

It's easy to miss but did you include the period between INFORMATION_SCHEMA
and TABLES?

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

[quoted text, click to view]

Hi RABMissouri,

SELECT *
FROM INFORMATION_SCHEMA.TABLES

--

hi,
[quoted text, click to view]

for your convenience, you can perhaps have a look at a free graphical tool
you can find at http://www.asql.biz/en/DbaMgr.aspx..
further tools, both commercial and free, can be found at
www.microsoft.com/sql/msde/partners and
http://www.aspfaq.com/show.asp?id=2442
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
--------- remove DMO to reply

[quoted text, click to view]

Hi RABMissouri,

In addition to Rogers suggestion to check the period between
INFORMATION_SCHEMA and TABLES (there should be exactly one period, no
less, no more), can you also post the result of running this query:

SELECT @@VERSION
go



--