Results 1 to 2 of 2

Thread: List of all constraints for a field

  1. #1
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    1,948

    List of all constraints for a field

    syscolumnconstraints does not return all the constraint information for a column. Is there a way to get the missing constraints, e.g, those connected with mapping and suggestions, without opening the table and using the functions on each column? The information from afieldinfo and from select... stru extended also seems limited in this way.

    Am I missing a way to get all this information in one fell swoop?

    thanks,

    Hank

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,771
    Hi Hank,

    Currently thats the only way to do it as these were just added in 4.1.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

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