Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Toad for SQL Server 7.4 - Installation Guide

Table of Contents

SQL Server Objects

Edit Permissions on Objects Databases

About Databases Create and Alter Databases Edit Database Permissions Working with Databases

Manage Database Storage and Shrink Databases Back Up Databases

Back Up Databases Add Backup Devices

Restore Databases Bring Online / Offline Attach Databases Detach Databases Create and Revert Database Snapshots Check Databases

Generate DDL Scripts Generate Data Scripts

About Tables Create and Alter Tables Working with Tables

Check Tables Compile Dependencies Truncate Tables

Manage Table Partitions

Partition Tables Create Sliding Window Scenarios Switch Partitions

Bind and Unbind Columns

Bind and Unbind Columns to Rules Bind and Unbind Columns to Defaults

Create and Alter Table Statistics Enable or Disable Foreign Keys Enable or Disable Constraints

Create and Alter Views Indexes

Create and Alter Indexes Partition Indexes Defragment Indexes

Programmability

Stored Procedures

About Stored Procedures Create and Alter Stored Procedures Set Extended Stored Procedure Properties

About Functions Create and Alter Functions

Create and Alter Assemblies Create and Alter XML Schema Collections User-Defined Data Types (UDDTs)

About UDDTs Create and Alter UDDTs

Create and Alter Rules Bind Rules to Columns Bind Rules to UDDTs

About Defaults Create and Alter Defaults Bind Defaults to Columns Bind Defaults to UDDTs

Create and Alter Synonyms Security

Database Security

Create and Alter Users Edit User and Role Permissions Set Column Permissions Create and Alter Schemas Create and Alter Asymmetric Keys Create and Alter Certificates Create and Alter Symmetric Keys

Create and Alter Roles Server Security

Create and Alter Logins Set User Mapping

Create and Alter Credentials Create and Alter Firewall Rules (Azure)

Create and Alter Full Text Catalogs Create and Alter Partition Schemas Create and Alter Partition Functions

Create and Alter Sequences Table, Database and Server Triggers

Create and Alter Table, Database and Server Triggers Enable or Disable Table Triggers

Cycle Log Files Shrink Log Files

Kill Processes Resource Governor

Create and Alter Resource Pools Create and Alter Workloads

Edit Agent Properties

Define Agent Properties View Agent Error Logs Define Advanced Agent Properties Set Up Alert Systems Set Up Job Systems Define Agent Connections View Agent History

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

Select the Full Text Catalogs node under the Storage node in the Object Explorer.
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.
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

Select the Partition Schema node under the Storage node in the Object Explorer.
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.
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

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

Select the Partition Function node under the Storage node in the Object Explorer.
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.
Complete the fields as necessary.

Related Topics

Create and Alter Partition Schemas

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center