I can open a SQL Server CE 4.0 .sdf file in Visual Studio 2012 and it appears in the Server Explorer. All good.
But as far as I can tell it only shows the regular tables, not system tables.
Is there a way to show system tables?
Asked
Active
Viewed 997 times
1
marc_s
- 732,580
- 175
- 1,330
- 1,459
Jack Ukleja
- 13,061
- 11
- 72
- 113
1 Answers
2
No, in order to see them, you must type for example:
SELECT * FROM INFORMATION_SCHEMA.TABLES
Which also means you must know the name in advance (the command above lists all available tables by the way)
ErikEJ
- 40,951
- 5
- 75
- 115