O'Reilly logo

Visual Basic® .NET Database Programming by Rod Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Program ExploreServer

Example program ExploreServer, shown in Figure 13.4, uses SQL Server’s stored procedures to study a server. It uses the sp_databases stored procedure to list the server’s databases. For each database in the server, it uses sp_tables to list the database’s tables. For each table in the databases, it uses sp_columns to list the table’s columns.

Figure 13.4. Program ExploreServer uses SQL Server’s system stored procedures to list a server’s databases, tables, and columns.

Program ExploreServer uses the code shown in Listing 13.4 to display the server’s structure. When the user selects the File menu’s Server command, the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required