Results 1 to 2 of 2

Thread: sql Query

  1. #1
    Join Date
    Jul 2004
    Posts
    34

    Unanswered: sql Query

    Hi all
    HOw will i able to know what is the check constraints imposed on a particular table.? Is there any query to view the value of check constraints?
    Thanks

  2. #2
    Join Date
    Mar 2004
    Posts
    205
    You can use this query :

    select search_condition from user_constraints where table_name='TABLE_NAME' and constraint_type='C'

    Rgds,
    Sam.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •