Program ExploreRelations
Example program ExploreRelations uses SQL Server’s stored procedures to study the relations between tables in a database. Select the File menu’s Server command to pick a server and database to examine. The program loads information about the database’s tables and displays it in a DataGrid control. Initially the grid is collapsed. Click on the plus sign to see a list of tables similar to the one shown in Figure 13.5.
Figure 13.5. Program ExploreRelations lists the tables in a database.
When you click on one of the tables, the DataGrid displays information about the table’s columns. Figure 13.6 shows the results for the ...
Get Visual Basic® .NET Database Programming 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.
