サポートと今すぐチャット
サポートとのチャット

Toad for SQL Server 7.4 - Installation Guide

SQL Server Objects
Edit Permissions on Objects Databases Tables Create and Alter Views Indexes Programmability Create and Alter Synonyms Security Storage Create and Alter Sequences Table, Database and Server Triggers Management Agent

Compile Dependencies

Use this option to recompile stored procedures or triggers that are dependencies for one or more tables.

To compile dependencies

  1. Select Tables from the Databases node in the Object Explorer.
  2. Right-click one or more tables, and select Tasks | Compile Dependencies.

 

Related Topics

Truncate Tables

You can delete all data from a table using this feature.

Caution: You cannot rollback changes if you truncate data.

To truncate a table

  1. Select Tables from the Databases node in the Object Explorer.
  2. Right-click one or more tables, and select Tasks | Truncate Tables.

   

Related Topics

Manage Table Partitions

Partition Tables

Partitioning a table arranges the data into smaller more manageable pieces. The CPU can perform operations on more than one partition simultaneously, which improves performance. A very large database performs best if the partitions use multiple disks, separate filegroups, and preferably multiple CPUs.

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To partition a table

  1. Select Tables from the Databases node in the Object Explorer.

  2. Right-click a table and select Storage | Create Partition.
  3. Complete the wizard.

Tips:

  • You can right-click a partitioned table and select Storage | option to manage or undo the table partition.
  • You can right-click a table and select Storage | Unused Objects to remove unused partition schemes and functions.

  

Related Topics

関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択