Viewing a Local Database Schema
Visually exploring your database schema can help to reveal inadequacies in its structure. Missing indexes and foreign key relationships can be overlooked when relying solely on metadata in your code. In addition, having the capability to arbitrarily query your tables to see what is in your database can be useful during development.
Given that SQL CE database files usually reside in isolated storage, however, makes exploring the schema difficult.
This section looks at tools to retrieve your local database file from isolated storage and at using Visual Studio and SQL Server Management Studio to view the database on your desktop.
Get Windows® Phone 8 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
