SQL Schema Explorer by Tim Abell



Nearest Tables

Tap a table in the diagram to jump straight to it. Tap & drag in a gap to pan around. Tap & drag a table to re-arrange the diagram.

Tap the "enable zoom" button, then use the mouse wheel to zoom in to where the mouse pointer is.

Customised table layout is not remembered. Refresh the page to reset the diagram.


Name Type Nulls Outbound Foreign Key Inbound Foreign Keys Indexes
Primary Key MediaTypeId INTEGER NOT NULL Track(MediaTypeId) IPK_MediaType
Name NVARCHAR(120) Nullable

Foreign Keys


From To
Track(MediaTypeId) MediaTypeId


Name Columns Unique
IPK_MediaType MediaTypeId Unique


Skip to Data Controls Show just the data
sort MediaTypeId sort Name Referenced by
1 MPEG audio file Track: MediaTypeId - 3034 rows
2 Protected AAC audio file Track: MediaTypeId - 237 rows
3 Protected MPEG-4 video file Track: MediaTypeId - 214 rows
4 Purchased AAC audio file Track: MediaTypeId - 7 rows
5 AAC audio file Track: MediaTypeId - 11 rows
No earlier pages
No more pages
5 rows in table
5 rows shown
Showing rows 1 to end

Switch to card view
^ top