Home

Objects should not be duplicated (same name and same type)

Description

    The rule "Objects should not be duplicated (same name and same type)" states that within a SQL Server database, objects should not have the same name and type. This means that if an object of a certain type (e.g. table) with a certain name already exists, then an additional object of the same type and name should not be created. This is important to ensure that the database is organized and efficient, and that objects are not unnecessarily duplicated.

Key Benefits

  • Reduced complexity: Objects with the same name and type are not duplicated, which helps to reduce complexity.
  • Improved code maintainability: Code is easier to maintain when objects are not duplicated.
  • Reduced memory usage: Objects that are not duplicated require less memory.
  • Better performance: Objects that are not duplicated can be accessed more quickly and efficiently.

 

Visual Expert 2024
 VETSQLRULE85