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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Starting and connecting to your database » Tutorial: Creating a SQL Anywhere database


Lesson 3: Setting a NOT NULL constraint on a column

Use the following procedure to add a NOT NULL constraint to a column.

 Add and remove a constraint on a column
  1. In the left pane of Sybase Central, double-click Tables.

  2. Click Products, and then click the Columns tab in the right pane.

  3. Click the ProductName column.

  4. Click File menu, click Properties.

  5. Click the Constraints tab and click Values Cannot Be NULL.

    By default, columns allow NULLs, but it is good practice to declare columns NOT NULL unless there is a good reason to allow NULLs. See NULL special value.

  6. Click OK.

    This constraint means that for each row added to the Products table, the ProductName column must have a value.

  7. In the File menu, click Save.

  8. Proceed to Lesson 4: Creating a foreign key.

 See also