colum. Pight-click on the Vendors table and select the Design command to display the Vendors table in a Table Designer tab. Review the properties for each column in this table. In particular, note that the VendorID column is defined as an identity column. . . 1 1 : 1 Chapter 2 How to use the Management Studio 81 Ered Duw wong Tracongco Totes Entered By G Developers he exercises for this chapter r own PC, you'll need to set up your system as and B before you can do these exercises. In install SQL Server Express and the Management red in appendix A. In addition, you'll need to files that come with this book as described in Exercises 1. Use the Management Studio to view al from the server. If the AP database isn't availah anagement Studio to view all of the databases that are available er. If the AP database isn't available, follow the procedure in dix B to create it. Then, view the tables that are available from the AP Finally, view the columns that are available from the Invoices table Note the primary and foreign keys of this table and the definition for each column. isht click on the Vendors table and select the Design command to display the Vendors table in a Table Designer tab. Review the properties for each column in this table. In particular, note that the VendorID column is defined as an identity column. Use the Management Studio to view the diagram for the AP database. Then. organize the tables and connecting lines in the diagram so they are easy to read. (Hint: You can use the Autosize Selected Tables button and the Arrange Tables button in the toolbar to help you do this.) Finally, review the information that's contained in each table, note the primary key of each table, and try to identify the relationships between the tables. 4. Open a new Query Editor window and then enter this SELECT statement: SELECT VendorName, Vendorstate FROM Vendors WHERE Vendor State = 'CA'; Press F5 to execute the query and display the results. If an error is displayed, correct the problem before you continue. (Hint: If you get an error message that indicates that 'Vendors' isn't a valid object, the AP database isn't the current database. To fix this error, select the AP database from the Available Databases combo box.) Then, save the query with a name of VendorsInCA and close it. 5. Open the query named Vendors InCA that you saved in exercise 4. Then, click the Execute Query toolbar button to execute it. 6. Display Books Online and look up information about the Query Editor. The easiest way to do this is to use the full-text search to look up query editor" and then select the appropriate topic. Then, click on some links in the topic, navigate to some related topics, and use the Back button to return to the Original topic. Continue experimenting until you feel comfortable. colum. Pight-click on the Vendors table and select the Design command to display the Vendors table in a Table Designer tab. Review the properties for each column in this table. In particular, note that the VendorID column is defined as an identity column. . . 1 1 : 1 Chapter 2 How to use the Management Studio 81 Ered Duw wong Tracongco Totes Entered By G Developers he exercises for this chapter r own PC, you'll need to set up your system as and B before you can do these exercises. In install SQL Server Express and the Management red in appendix A. In addition, you'll need to files that come with this book as described in Exercises 1. Use the Management Studio to view al from the server. If the AP database isn't availah anagement Studio to view all of the databases that are available er. If the AP database isn't available, follow the procedure in dix B to create it. Then, view the tables that are available from the AP Finally, view the columns that are available from the Invoices table Note the primary and foreign keys of this table and the definition for each column. isht click on the Vendors table and select the Design command to display the Vendors table in a Table Designer tab. Review the properties for each column in this table. In particular, note that the VendorID column is defined as an identity column. Use the Management Studio to view the diagram for the AP database. Then. organize the tables and connecting lines in the diagram so they are easy to read. (Hint: You can use the Autosize Selected Tables button and the Arrange Tables button in the toolbar to help you do this.) Finally, review the information that's contained in each table, note the primary key of each table, and try to identify the relationships between the tables. 4. Open a new Query Editor window and then enter this SELECT statement: SELECT VendorName, Vendorstate FROM Vendors WHERE Vendor State = 'CA'; Press F5 to execute the query and display the results. If an error is displayed, correct the problem before you continue. (Hint: If you get an error message that indicates that 'Vendors' isn't a valid object, the AP database isn't the current database. To fix this error, select the AP database from the Available Databases combo box.) Then, save the query with a name of VendorsInCA and close it. 5. Open the query named Vendors InCA that you saved in exercise 4. Then, click the Execute Query toolbar button to execute it. 6. Display Books Online and look up information about the Query Editor. The easiest way to do this is to use the full-text search to look up query editor" and then select the appropriate topic. Then, click on some links in the topic, navigate to some related topics, and use the Back button to return to the Original topic. Continue experimenting until you feel comfortable