Rick Mathers

Member since 1 year ago

Badges

• Newbie

4 ideas posted

4 comments 8 votes

71 points View the Leaderboard

Rick Mathers is a member of:

• Idea Pond
• Toad for SQL Server Idea Pond

Activity Stream

Ideas contributed by Rick Mathers

• I agree

  2 votes

  This idea is active.
  Object Explorer / Schema Browser »

  Default Value Constraint Name

  I have been unable to locate a way to rename a constraint for a default value and that the values that are being created are generally different from server to server since it is creating random characters at the end of the constraint. For Example: [DF__MyTable__lastM__5A30FF58] I would really like a way to name the constraint during creation or at least a way to rename the constraint that was created. I am always ...more »

  I have been unable to locate a way to rename a constraint for a default value and that the values that are being created are generally different from server to server since it is creating random characters at the end of the constraint.

  For Example: [DF__MyTable__lastM__5A30FF58]

  I would really like a way to name the constraint during creation or at least a way to rename the constraint that was created. I am always have to watch scripts that get created with the schema change to make sure that values with those random characters are not in it, otherwise the script will fail on remote servers since they are generally different.

  « less full details »

  4 comments for Idea: Default Value Constraint Name

  Submitted by Rick Mathers 1 month ago

• 4 votes

  This idea is closed.
  SQL Editor »

  Refresh Issue with Constraint Form

  Using Version 5.7.0.605

  I found that when you change the selection of the Constraint in the Table Constraints List, the Primary Table does not refresh until after the user mouses over the DropDownEdit Control. This is not a big issue to me, it just through me off a bit when I was naming the constraints.

  1 comment for Idea: Refresh Issue with Constraint Form

  Submitted by Rick Mathers 10 months ago

• I agree

  4 votes

  This idea is active.
  Data Compare »

  Optional Identity Insert By Table

  When generating the scripts for the data compare, there is an option to turn on/off "Exclude Identity Columns". In my particular scenerio, I have some tables that need the identity columns included, then I have others that do not need them. I know that the generated script can be edited manually, but I think it would be nice to be able to specify (optionally, of course) the Exclude Identity Columns on a per table basis ...more »

  When generating the scripts for the data compare, there is an option to turn on/off "Exclude Identity Columns". In my particular scenerio, I have some tables that need the identity columns included, then I have others that do not need them. I know that the generated script can be edited manually, but I think it would be nice to be able to specify (optionally, of course) the Exclude Identity Columns on a per table basis or for the entire script.

  « less full details »

  Add your comment for Idea: Optional Identity Insert By Table

  Submitted by Rick Mathers 10 months ago

• I agree

  4 votes

  This idea has been completed.
  SQL Editor »

  Add Constraint - NOCHECK Option

  When adding a constraint using the alter table window, I see that when adding a FK constraint, the ability to use the NOCHECK option is not there, the user has to export the generated SQL to the editor and alter the script to change it from CHECK to a NOCHECK.

  1 comment for Idea: Add Constraint - NOCHECK Option

  Submitted by Rick Mathers 1 year ago

• I agree

  2 votes

  This idea has been completed.
  Schema Compare »

  Statistics Drop Needs Check

  When generating the output script for a schema compare, the drop for statistics is not being wrapped in a check to make sure the statistic exists.

  For example:

  USE AdventureWorks2008R2;

  GO

  IF EXISTS (SELECT name FROM sys.stats

  WHERE name = N'ContactPromotion1'

  AND object_id = OBJECT_ID(N'Person.Person'))

  DROP STATISTICS Person.Person.ContactPromotion1

  GO

  2 comments for Idea: Statistics Drop Needs Check

  Submitted by Rick Mathers 1 year ago

Displaying all 5 Ideas