The Database Designer and Table Designer provide property pages with which you can create, delete, and modify database objects, and set other options that affect them.
To | See |
---|---|
Set properties for database tables | Tables Property Page |
Set properties for columns | Columns Property Page |
Create and manipulate relationships between tables, including choosing primary and foreign keys for the relationship | Relationships Property Page |
Create and manipulate indexes, primary keys, and unique constraints attached to a table | Indexes/Keys Property Page |
Create and manipulate check constraints | Constraints Property Page |