Viewing a Table
After you have created the tables in a database, you may have to find information about the table properties, such as the name or data type of a column or the nature of its indexes, but most importantly, you will have 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
To view the data in a table
To obtain information about tables
To obtain information about table columns
To obtain information about table columns that are computed
sys.computed_columns (Transact-SQL)
To view the dependencies of a table
sys.sql_expression_dependencies (Transact-SQL)