Get table names from database

[ManicCW]

I need to get table names using datareader. Now I know how to do that using INFORMATION_SCHEMA query but this retrives some system tables. How can I retrive only user tables?

 

[VishalAdsool]

Hi ManicCW,
You may want to try this out...

Dim index As Integer
SqlConnection = New SqlConnection("server=Localhost;Database=NorthWind;uid=sa")SqlConnection.Open()
SqlCommand = New SqlCommand("Select Name FROM dbo.sysobjects WHERE xtype = 'U'", SqlConnection)

SqlCommand.CommandType = CommandType.Text

SqlDataReader = SqlCommand.ExecuteReader()
While SqlDataReader.Read

ComboBox1.Items.Add(SqlDataReader.Item(0))

End While


SqlDataReader.Close()

SqlConnection.Close()

Regards,
Vishal Adsool

 

[ManicCW]

Thank you I will try that but I have heard that this method is not recommended anymore and that we shold use sheme method.

But thanks.

 

[nakracreative]

no its impossible to retrieve tablenames from datareader object. datareader retrieves data only in forward mode and that too in read only format. its sole pupose is to retrieve the data from the data source and not the tablenames.