Get list of my tables in my database MSDE

  • Thread starter Thread starter Romain TAILLANDIER
  • Start date Start date
R

Romain TAILLANDIER

Hi group

I have a database, I need to get the list of the tables by a SQL query,
dynamically at runtime, to put them in a combobox (for example).
I am not able to found any help on that topic, i still searching ...

Please indicate me some link :)

Thank you for your help.
 
Please note that i don't know anything about database, juste have SQL
notions.

I found something, but ...

SELECT * FROM sysObjects where xtype = 'U'
I get list of all my table. but i have some table i don't need (and i don't
know what they are), like spt_fallback_db,spt_fallback_dev,stp_values,
dtpoperties etc...
there is 11 'parasites' system tables, which i don't need. I remark that the
field category have the value 2048 for the table i want to list. Can i use
the catgory to list the tables ?

where can i get help on that ?
thanks for any help.
ROM
 
try searching books online. start with sp_tables. u can also look
under informationschema.
 
Back
Top