getSchema multiple tables

[jkhome]

I'm using .net 2 and the getschema function of the db connection to get database schema.

This is the code i'm using to get the schema. How do i get schema for

multiple tables at once using the same code

restrictions(0) = database

restrictions(1) = owner

restrictions(2) = table

newTable = dbConnection.GetSchema("columns", restrictions)

[azcodemonkey]

That is how you get multiple table schemas. You're getting the schema for the database you're connected to.

I think you're doing your restrictions incorrectly.

The first element is which catalog to use, the second is the owner(e.g. dbo), the third is the table name(e.g. Authors), and the fourth is table type. So, if you want all the tables that belong to dbo, you only need to specify that the second element of the restrictions array is "dbo".

This gets all the tables that belong to dbo.

  Dim connectionString As String = GetConnectionString()
  Dim restrictions(3) As String
  Using connection As New SqlConnection(connectionString)

    'Connect to the database, and then retrieve the 
    'schema information.
    connection.Open()
    restrictions(1) = "dbo"
    Dim table As DataTable = connection.GetSchema("Tables", _
       restrictions)

    ' Display the contents of the table.
    DisplayData(table)
    Console.WriteLine("Press any key to continue.")
    Console.ReadKey()
  End Using

If you omit the restrictions parameter altogether, you'll get all the tables, system and otherwise, for the current database.

[jkhome]

  weenur said:

That is how you get multiple table schemas. You're getting the schema for the database you're connected to.

I think you're doing your restrictions incorrectly.

The first element is which catalog to use, the second is the owner(e.g. dbo), the third is the table name(e.g. Authors), and the fourth is table type. So, if you want all the tables that belong to dbo, you only need to specify that the second element of the restrictions array is "dbo".

This gets all the tables that belong to dbo.

 ?Dim connectionString As String = GetConnectionString()
 ?Dim restrictions(3) As String
 ?Using connection As New SqlConnection(connectionString)

 ? ?'Connect to the database, and then retrieve the 
 ? ?'schema information.
 ? ?connection.Open()
 ? ?restrictions(1) = "dbo"
 ? ?Dim table As DataTable = connection.GetSchema("Tables", _
 ? ? ? restrictions)

 ? ?' Display the contents of the table.
 ? ?DisplayData(table)
 ? ?Console.WriteLine("Press any key to continue.")
 ? ?Console.ReadKey()
 ?End Using

If you omit the restrictions parameter altogether, you'll get all the tables, system and otherwise, for the current database.

586695150[/snapback]

But how would i get just two tables and not all of them or just one table

[azcodemonkey]

OK, I see what you're getting at. You can't do it the way you want, apparently. The docs don't show a way to get multiple tables with the restrictions array.

What you could do is do a dynamic SQL query to select from the tables you want schema info from, and then use the DataTables(DataSet.Tables) you get back to get primary keys, or any other info.

What exactly are you trying to get from the schema?