How to get Datebase name and tables in sql-server?

[¹ùÑÇ·æ]

In my app,I want to bind Database names with a comboBox in order to
select which database i wanto open .
and I also wanto bind table names with a comboBox, So i can select which
table i wanto use !

how can i code in c# ?

Thanks a lot for any comments !

 

[Peter Rilling]

You might try calling the sp_tables and sp_databases stored procedures.

 

[Donald E. Hurley Jr.]

You can use the INFORMATION_SCHEMA views in the master database.

to get database:

Select * from INFORMATION_SCHEMA.SCHEMATA

to get tables:

SELect * from INFORMATION_SCHEMA.TABLES where table_catalog = 'Master' or
whatever database you pick.

Hope this helps.
Don

 

[¹ùÑÇ·æ]

Thank you !

i found "select * from sysobjects where xtype='U'" also work well.
but i do not sure if this is correct in coding .

 

[Donald E. Hurley Jr.]

I think it is recommended to go off the INFORMATION_SCHEMA views. Lots of
good stuff built in there for you.

Don