Viewing a Table

Creating and Maintaining Databases

Creating and Maintaining Databases

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-SQL

Enterprise Manager

SQL-DMO

To view the data in a table

Transact-SQL

Enterprise Manager

To view the dependencies of a table

Transact-SQL