Home > Archive > C# > September 2005 > List of tables in a database (C#)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
List of tables in a database (C#)
|
|
| Maziar Aflatoun 2005-09-08, 6:58 pm |
| Hello,
How do you get a list of all tables in a sql server database using C#?
Thanks
Maz.
| |
| Jan Bannister 2005-09-09, 6:59 pm |
| Hi Maziar,
It's not a C# question now is it?
But it's ok I'll tell you.
You this query Select * From INFORMATION_SCHEMA.Tables
and see what you get back ...
Good Luck,
Jan
| |
| Jan Bannister 2005-09-12, 7:59 am |
| "You this Query" ???
I'm really losing it...
"Use this Query", is what i ment.
Jeez
| |
| joelcochran@gmail.com 2005-09-14, 9:56 pm |
| Just a warning that from what I've been reading this will no longer
function as desired in SQL Server 2005. At that point, you will need
to query "sys.tables" instead (or something like that)
Joel
|
|
|
|
|