List of tables via query

[Durandal66]

I was wondering if there was a way to generate a list of all the tables in a database by using an SQL Query. I have found methods of doing this with Java using their libraries, but I would much rather do it using straight SQL. If this is not possible, perhaps there is a way using C#? Thanks in advance!

-Andrew R.

 

[hvass]

show tables from mydatabase;

 

[Durandal66]

I guess I should have mentioned that im using MSSQL. Sadly, the show statement isnt recognized. Any other ideas?

-Andrew R.

 

[hvass]

I give up, shoot me down but ... what about asking on a Microsoft forum

 

[Durandal66]

Thanks for the effort, I have been smashing my head on a wall over this one for awhile too.

-Andrew R.

 

[vanekl]

I don't play in MS SQL's sandbox (lately) but I think
the query you want goes like this:

select name from master.sysobjects where xtype = "U"
or type = "U"

Found the MS SQL table definitions at

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-d_5xrn.asp

 

[Durandal66]

I found that sending the command "sp_help" does the trick nicely. This returns all views, system tables, user tables, stored procedures, primary key constraints, and the default constraint. This data is presented in three columns, Name, Owner and Object_Type. I built a data reader (C#) that stored only the rows that were user tables (stuff I created), and used it in my application. Not the most elegant way, but the data this call returns will come in handy later in my application, so all is well. Thank you for your help!

-Andrew R.

 

[danielhozac]

May I ask what this has to do with MySQL?

//Daniel