You can use the Visual Database Tools to design a database and create database objects.
Database object names must be unique within a database. The database management system (DBMS) enforces certain rules to ensure that objects have unique names. When you name database objects you will be alerted if the name you provide is already used by another object.
If you provide a duplicate name that is detected by Visual Database Tools, you will receive an error as soon as you try to name the object. If you provide a duplicate name that is detected by the DBMS, Visual Database Tools will initially accept the name, but the DBMS will reject the name when you try to save the object to the database.