Database Objects

  • Article

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.

In This Section

Aggregate Functions

Check Constraints (Visual Database Tools)

Columns (Visual Database Tools)

Foreign Keys (Visual Database Tools)

Indexes (Visual Database Tools)

Primary Keys (Visual Database Tools)

Stored Procedures (Visual Database Tools)

Tables (Visual Database Tools)

Table-Valued Objects

Triggers (Visual Database Tools)

Unique Constraints (Visual Database Tools)

User-Defined Functions

Views (Visual Database Tools)

Reference

Reference (Visual Database Tools)

Designing Tables

Understanding Visual Database Tools