enumerating table names

  • Thread starter Thread starter S.Kartikeyan
  • Start date Start date
S

S.Kartikeyan

How to enumerate table names in a database which are created by me and
not systables in my C# program. I am using SQLServer2000
If i use in SqlDataAdapter i get only one table
 
How to enumerate table names in a database which are created by me and
not systables in my C# program. I am using SQLServer2000
If i use in SqlDataAdapter i get only one table
Click to expand...

How are you using SqlDataAdapter? The following query will return all
tables names that are user-defined tables:

select name from sysobjects where type = 'U'

You can either run that query and get back a datareader or use it to
fill a DataSet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enumerator 2
Enumeration and Class 4
DataGrid - Float Fields 3
about understanding 4
Enumerating all controls on a Win Form 2
Why is there no default name for a DataTable here adapter.Fill(dt); 2
Enumeration 2
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top