Click to Rate and Give Feedback
Collapse All/Expand All Collapse All
This page is specific to
Microsoft Visual Studio 2010/.NET Framework 4

Other versions are also available for the following:
How to: Change the Default Generator for a Column Type

In a data generation plan, every SQL data type has a default data generator that is automatically assigned to the columns in the generation plan. You can change the default generator that is associated with a SQL data type.

To change the default generator that is associated with a SQL data type

  1. On the Tools menu, click Options.

    The Options dialog box opens.

  2. In the Options dialog box, expand the Database Tools node, expand the Data Generator node, and click Default Generators.

  3. Click the database schema provider for which you want to specify a default generator.

  4. Click the row of the SQL data type for which you want to change the default generator.

  5. Click the Default Data Generator column, click the down arrow, and click a different default generator.

    If you have installed any custom generators and then restarted Visual Studio Premium, they will appear in the list where appropriate.

    NoteNote

    Not all generators can be used with all SQL data types. The list displays only the generators that are available for the SQL data type of the column. For example, you can assign an Integer generator to an int or bigint column but not to a tinyint or smallint column. Also, you can set only those generators that produce unique values as default generators.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2012 Microsoft. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker