List all SQL instances, and their tables

Question

I want to list all SQL server instances and their tables.

I have code that lists all the servers correctly but I cannot seem to get a list of their tables.

        DataTable dataSources = SqlDataSourceEnumerator.Instance.GetDataSources();
        foreach (DataRow row in dataSources.Rows)
        {
            Console.WriteLine("Server Name:" + row["ServerName"]);

            foreach (var item in row.ItemArray)
            {
                Console.WriteLine(" - Item: "+ item);
            }
        }

possible duplicate of [How to list available instances of SQL Servers using SMO in C#?](http://stackoverflow.com/questions/1130580/how-to-list-available-instances-of-sql-servers-using-smo-in-c) — Mitch Wheat, Aug 04 '10 at 14:03
That shows how to get server names not table names, thanks though — Chris, Aug 04 '10 at 14:06

score 2 · Accepted Answer · answered Aug 04 '10 at 14:06

2

You can query what tables are in a db using sys.Tables. See below:

USE YourDBName
GO
SELECT name FROM sys.Tables
GO

answered Aug 04 '10 at 14:06

Abe Miessler

82,532
99
305
486

That would mean I have to be authenticated on that server to be able to see table names doesn't it? – Chris Aug 04 '10 at 14:08
2

authentication is a standard requirement for obtaining data! – Mitch Wheat Aug 04 '10 at 14:12
1

Yes that is correct, if you want information about the database you will need to be authenticated. This is a good thing. – Abe Miessler Aug 04 '10 at 14:12

List all SQL instances, and their tables

1 Answers1