Exercise: Automate Suggested Constraints

  1. Right click DSA node and choose Automate -> Add Suggested Constraints
  2. In the window "Select Fields to Include in Primary Key" click Add All button followed by Next
  3. In the window "Select Fields to Relate to Other Fields" click Next button
  4. In the window "Review Your Selections" click Finish button
  5. Deploy and Execute the project using option "Only modified tables and views"

Expand one or more tables to check, that primary keys have been assigned.