Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal
< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7
You are here: Manage Databases > Work with Objects > Create Objects Based on Existing Objects

Create Objects Based on Existing Objects

Use this feature to create a new object based on an existing object including any properties for that object.

Scenario

You have an existing "employee" table that includes the following columns:

  • ID

  • FirstName

  • LastName

  • Phone

  • Address

  • City

  • State

  • Zip

With Create Like, you can quickly create a customer table without having to re-create the same columns.

To use Create Like

  1. Select an object in the Object Explorer.

  2. Click Create Like on the toolbar (SHIFT+F10+R).

    An on the toolbar indicates a create like action.

  1. Modify the pages in the window.

    Note: Any errors or incomplete required fields display in the lower left of the window. Click the error to display the field where the error occurs.