18

I have a database in SQL CE (sdf file) and I need to get all names of the tables.

How to do it?

Uwe Keim
  • 39,551
  • 56
  • 175
  • 291
Gold
  • 60,526
  • 100
  • 215
  • 315

1 Answers1

32
select table_name from information_schema.tables where TABLE_TYPE <> 'VIEW'
dcp
  • 54,410
  • 22
  • 144
  • 164