Tables Property Page

See Also      Tasks

This property page contains a set of properties for the tables in your database diagram and their check constraints.

Selected table

Shows the name of the selected table in your diagram. If more than one table is selected in your diagram, only the name of the first table in your selection is visible. Expand the list to choose a different table to show properties for.

Table name

Shows the name of the selected table. To rename the table, enter a new name in this box. For more information, see Renaming a Table.

Check constraints for table and columns

You can add or edit a check constraint in this dialog box. For more information about adding check constraints, see Attaching a New Check Constraint to a Table or Column.

• Selected constraint   Shows a list of the check constraints attached to the selected table.
  
  
• New   Creates a new check constraint for the selected table.
  
  
• Delete   Deletes the selected check constraint from the database.
  
  
• Constraint expression   Shows the SQL syntax of the selected check constraint. For new constraints, you must enter the SQL syntax before exiting this box. You can also edit existing check constraints. For more information, see Defining a Check Constraint Expression.
  
  
• Constraint name   Shows the name of the selected constraint. You can rename the constraint by entering a new name in this box.
  
  
• Check existing data on creation   When selected, this option ensures that all data that exists in the table before the constraint was created is verified against the constraint.
  
  
• Enable constraint for INSERT and UPDATE   Applies the constraint when data is inserted into or updated in the table.
  
  
• Enable constraint for replication   Applies the constraint when the table is copied in a different database.