Results 1 to 3 of 3

Thread: How to set table constraint and column constraint in data workspace?

  1. #1
    Senior Member
    Join Date
    Jul 2019
    Posts
    175

    How to set table constraint and column constraint in data workspace?

    Hi Guys,

    May I know which column attribute I should use to set the table constraint and column constraint in the data workspace?

    Thanks & Best Regards

  2. #2
    Senior Member
    Join Date
    Jan 2014
    Posts
    351
    Hi WJ

    It is not necessary to set constraints as I know.
    Just build the tables using the Lianja data workspace and related the tables by joining the section headers.

    Thanks & best Regards

  3. #3
    Senior Member
    Join Date
    Jan 2014
    Posts
    351
    Hi WJ

    For best practice, the PK of a table should be a single field only

    You need to use ALTER TABLE command to set the PK field for a table

    Thanks & Best Regards

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us