Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Data integrity » Table and column constraints


Managing constraints

In Sybase Central, you can add, alter, and drop column constraints on the Constraints tab of the table or Column Properties window.


You must be the owner of the table the column belongs to, or have one of the following privileges:

  • ALTER privilege on the table
  • ALTER ANY TABLE system privilege
  • ALTER ANY OBJECT system privilege
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, double-click Tables.

  3. Double-click the table you want to alter.

  4. In the right pane, click the Constraints tab and modify an existing constraint or add a new constraint.


The column constraints are displayed.


Modify the constraints as needed.

 See also