Hello everybody,

I don't usually hang out in this group, but it looks like the
only place to post this. Since I originally installed the
Framework, I've had a version of SQL Server, I think it's
called desktop edition or something along that line. It's
nice to have and be able to use, but it lacks any kind of
GUI for administering databases and such. Given this, I
though to myself, I said: "Self, since there is no real
interface to the SQL Server, it would be a good idea
and a nice exercise to try and write one in C#". So, I
began to learn about the classes that are available and
such. Soon I decided that, based on an example program
I have, it shouldn't be a monumental undertaking, but
would definitely involve a decent learning curve.

What myself and I soon discovered was that there seems
to be no way to do the simple task of getting a list of
tables, something that would most definitely be part of a
GUI for a database server! I've Googled around a bit, and
even read some posts in this group, but I have yet to see
a useful demo, example or explanation of how/if this can
be accomplished.

Before I become totally disheartened (not to mention
wasting several hours pulling hair out), can anyone tell
me if this is possible using totally safe code, and if so
how/where can I find a good article or sample? It just
seems to me that there are probably many people who
would have this need, so why the heck is it so difficult,
if not impossible?

Please?

try
"select object_name(id) object
from sysobjects
where type in ('U', 'V', 'P') and ObjectProperty (id, N'IsMSShipped') = 0"