Chat now with support
Chat with Support

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

Storage

Create and Alter Full Text Catalogs

The Full Text Catalog displays any full text categories in your database.

Tip: 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. See Object Options for more information.

To create or alter a full text catalog

  1. Select the Full Text Catalogs node under the Storage node in the Object Explorer.
  2. Select one of the following:
    • Click to create a full text catalog.
    • Select a full text catalog and click to create a full text catalog like the selected one.
    • Select a full text catalog and click to alter it.
  3. Complete the fields as necessary.

Tip: You can right-click a full text catalog and select Enable or Disable Full Text Catalog.

 

 

 

Create and Alter Partition Schemas

Tip: 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. See Object Options for more information.

To create or alter a partition schema

  1. Select the Partition Schema node under the Storage node in the Object Explorer.
  2. Select one of the following:
    • Click to create a partition schema.
    • Select a partition schema and click to create a partition schema like the selected one.
    • Select a partition schema and click to alter it.
  3. Complete the fields as necessary.

Tip: You can select a partition function from the list or click New Partition Function to create a new one.

 

Related Topics

 

Create and Alter Partition Functions

Tip: 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. See Object Options for more information.

To create or alter a partition function

  1. Select the Partition Function node under the Storage node in the Object Explorer.
  2. Select one of the following:
    • Click to create a partition function.
    • Select a partition function and click to create a partition function like the selected one.
    • Select a partition function and click to alter it.
  3. Complete the fields as necessary.

 

Related Topics

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating