1.5. Viewing Table Definitions

Every table in SQL Server has a table definition. The table definition gives us information about a table such as the column names in the table, the data types of the columns in the table and whether the columns allow null (missing) values.

To view the definition of the Student table for example, expand the Student node by clicking on the + sign beside it, and then expand the Columns node, by clicking on the + sign beside it, as shown in Figure 1-20. You will be able to view the columns in the Student table. The columns in the Student table are stno, sname, major, class, and bdate.

Figure 1-19. Viewing the tables in the Student_coursedatabase