• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 21. Getting Started with Dynamic... > Exploring the Databases Panel

21.7. Exploring the Databases Panel

The Databases panel (Figure 21-12) lets you do more than just connect databases to your site. It also lets you explore the structure and content of a database. By clicking the + buttons (flippy triangles), you can view any of three lists:

  • Tables lists the tables in the database (see page 626); you can further expand this list to view the columns in each table. This is the option you'll use most often.

  • Views. A list of all views stored in the database. A view is a selection of data in the database—a slice of its data. Unless you've created views using the database systems tools, this list is empty.

  • Stored Procedures. A list of programs, stored in the database, that access and manipulate its information. Since they're stored within the database, they run faster than similar code stored in a Web page. (Some database systems—Access and MySQL, for example—don't recognize this feature.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint