[sattua]

I need to show all tables from a database, well I dont know how, look:


Try
sqlx.Open()
Dim ver As Object
Dim sqlstring As String = "select.......Idon`t know jaja"
Dim sqlc As New SqlCommand(sqlstring, sqlx)
ver = sqlc.ExecuteNonQuery()
sqlstring = Convert.ToString(ver)
ListView1.Items.Add(sqlstring)
Catch ex As Exception
MsgBox("No tables Found")
End Try

I need a query or something to list all tables... HOW???

[DeCompile]

Are you trying to list all the tables that are included in that database or are you attempting to view all the data from the tables?

They are actually two different things:

The first will give you a list of all the databases / tables that are contained within the SQL server.

The other will give all the data contained within the database/table you are querying.

[sattua]

nono, I have to show all the tables of a database...

maybe the code that I showed you, it is not completely well, but the idea is that to show all the tables



thanks......

[PsychoCoder]

You have two options, you can use

SELECT * FROM sysobjects WHERE type = 'U' 

Or for a more ANSI orientated result you can use

SELECT * FROM INFORMATION_SCHEMA.TABLES

[layaroo]

DeCompile, on 31 Jul, 2008 - 08:51 PM, said:

Are you trying to list all the tables that are included in that database or are you attempting to view all the data from the tables?

They are actually two different things:

The first will give you a list of all the databases / tables that are contained within the SQL server.

The other will give all the data contained within the database/table you are querying.

so how to get the list of database??
I am trying to get it and it is still couldn't find any information found on web sites yet.

[magicmonkey]

select * from sys.databases

Depending what you want to do you can also use the SQL SMO .NET objects to manage a SQL Server.