Viewing a Table
After you have created the tables in a database, you may need to find information about the table properties (for example, the name or data type of a column, the nature of its indexes, and so on). Additionally, and most importantly, you will need to view the data in the table.
You can also display the dependencies of the table to determine which objects, such as views, stored procedures, and triggers, depend on the table. If you make any changes to the table, dependent objects may be affected.
To view the definition of a table
Transact-SQLTo view the data in a table
To view the dependencies of a table
To view column properties
Viewing Foreign Key Attributes
View the foreign key attributes of a relationship if you want to see which columns participate in the foreign key side of a relationship. If the foreign key columns are related to a primary key, the primary key columns are identified in your database diagram by a primary key symbol in the row selector.
To view the foreign key attributes of a relationship
To view the constraints in a table