Export (0) Print
Expand All

Viewing a Table

SQL Server 2000

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

Enterprise Manager

SQL-DMO

To view column properties

Transact-SQL

Enterprise Manager

SQL-DMO

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

Transact-SQL

Enterprise Manager

SQL-DMO

To view the constraints in a table

Transact-SQL

SQL-DMO

See Also

Query Fundamentals

Viewing an Index

Show:
© 2014 Microsoft