How do you get a list of tables in a SQL Server DB?

[dietz]

I have an ASP.NET application in which I need to connect to a specific SQL Server database and then list all of the tables contained within that database.

How can I accomplish this?

[brucevde]

Are you asking how to get the list of table names from sql server or how to show them on a web page (or both)

If its the former then some options

1) Every SQL Server database has system Views that you can use to get schema information. Just run a query on the view. Something like

Select TableName From Information_Schema.Tables 
Where Table_Type = 'Base Table'

2) Use ADOX.

3) Access the sql server system tables directly.

[dietz]

Thanks.

[Memnoch1207]

or

SELECT * FROM sysobjects WHERE xtype = 'U'

[brucevde]

FROM sysobjects WHERE xtype = 'U'

Which is basically what the Information_Schema.Tables
View executes.