|
Learn more about Toad for SQL Server Find solutions and downloads at the |
|
|
Learn more about Toad for SQL Server Find solutions and downloads at the |
|
Toad for SQL Server 6.6 |
You can view details for a table by selecting it in the Object Explorer. The following describes the details associated with each table:
| Use this tab... | To display... |
|---|---|
|
Columns |
Columns included in this table. |
|
Data |
Data associated with the included columns. |
| Statistics | Includes statistics info for the table. See Create and Alter Table Statistics for more information. |
|
Indexes |
Indexes, primary keys, and unique constraints assigned to this table. |
|
Constraints |
Includes constraints used to enforce integrity for table columns, foreign and primary keys. |
|
Triggers |
Triggers that run automatically when you execute an Insert, Update, or Delete statement on the table. |
| Partitions | Displays partitions of the current table. |
|
Permissions |
Permissions granted to users for this object. |
|
Dependencies |
Dependent table objects and the objects that contain reference to the table. |
|
Extended Properties |
Extended properties you define to store additional metadata for this object. |
|
Script |
SQL statements for the selected object. |
Tips:
Right-click the object to see additional actions and tasks available for it.
You can change how objects display in the Object Explorer. For example, you can create custom categories or move objects out of existing categories (such as Programmability and Security) in Tools | Options | Explorer | Objects.
You can hide system tables from the list of displayed tables in Tools | Options | Database | SQL Server.
icon in the Object Explorer.