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

Check Databases

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions. See the Microsoft® Developer Network for more information.

You can check a single database or multiple databases for allocation or consistency errors.

To check a database

  1. Select the Databases node in the Object Explorer.

  2. Right-click a database and select Tasks | Check Database.
  3. Complete the fields as necessary. Specify options for each selected object individually. Review the following for additional information:

    No index Select True to exclude nonclustered indexes for user tables from the check operation.
    Physical only Select True to ensure that only physical integrity check are performed, that reduce the overall operation's duration.
    Set single user mode

    Select True to set single user mode, otherwise multi-user mode is on.

    Note: Single user mode is required for any type of repair.

 

Related Topics

Generate DDL Scripts

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

To generate DDL scripts

  1. Select Tools | Export | Generate DDL Script.

  2. Select one or more database from the list and click OK.

  3. Check the object types and select the required objects in Search Results pane.

    Tips:

    • Use to set searching options.

      You can search not only by date or object type or name (or part of it), but you can also specify a name (or part of it) of the higher level object to which the search object should belong to. To perform complex name search split the object name by dots and select Search in Name (split by dots) option.

      For example, you may find all columns named col1 belonging to the tables, that have "s" in their names - test.col1, sales.col1, etc.

    • Click at the upper right corner of the pane to open the Selected Objects pane.

      The Selected Objects pane displays the list of objects selected for the DDL generation, while the Search Results pane displays your current search results.

      For example, assume you search for tables and select three tables to add to the DDL generation. The tables are listed in the Selected Objects pane. When you perform another search, the previous table search disappears but the three selected tables remain in the Selected Objects pane.

      If you do not enable the Selected Objects pane, you can only select objects in the current Search Results to add to the script generation. You cannot select objects from multiple searches.

      To delete the object from the Selected Objects pane, click .

  4. Select to set Export DDL options.

    Complete the fields as necessary. Review the following for additional information:

    Script options

    Description

    Drops

    Select True to add a DROP statement for any objects included in the SQL script.

    Caution: This drops existing objects in the database before the CREATE statement using the existing definition is generated.

    Script permissions

    Select True to create all permissions for existing objects included in the script.

    Table script options

    Description

    Script indexes

    Select True to create indexes that currently exist for tables.

    Script triggers

    Select True to create triggers that currently exist for tables.

    Script keys, defaults, check constraints

    Select True to create keys, defaults, and check constraints that currently exist for tables.

    Note: You can create Profiles to store your preset options.

  5. Select to specify Output.

  6. Click .

 

Related Topics

Generate Data Scripts

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

To set data script options

  1. Select the Databases node in the Object Explorer.

  2. Right-click a database and select Generate Data Script.
  3. Click Add, and select tables to include in the script.

  4. Select the Options page.

  5. Complete the fields as necessary.  Review the following for additional information:

    Table scripting options

    Description

    Script tables

    Select True to create a script for the existing tables.

    Script dependent objects

    Select True to create a script for dependent rules, defaults, user-defined datatypes, and user-defined functions.

    Script indexes

    Select True to create indexes that currently exist for tables.

    Script full-text indexes

    Select True to create full text indexes.

    Script triggers

    Select True to create triggers that currently exist for tables.

    Script keys, defaults, check constraints

    Select True to create keys, defaults, and check constraints that currently exist for tables.

    Data scripting options

    Description

    Disable triggers

    Select True to disable all triggers for a table before filling data.

    Disable constraints

    Select True to disable all constraints for a table before filling data.

    Delete data from the table

    Select True to delete all data in the current table before filling data.

    Use transactions

    Select True to use transaction statements for INSERT statements.

    Number of records for one transaction

    Select the number of INSERTs to create for each transaction The default is 0, which includes all INSERT statements in one transaction.

    Formatting

    Description

    Include headers

    Select True to include a comment for each table in the script.  

    Use "use" keyword

    Select True to add the keyword "use" when separating tables in different databases.

 

Related Topics

Tables

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating