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.
 
Back
Top