#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2011
    Location
    Munich, Germany
    Posts
    3
    Rep Power
    0

    Firebird: Showing constraints / Client for Mac OS X


    Hey,

    I am looking for an SQL client that works with Firebird on Mac OS X.

    I tried RazorSQL, and it works quite well; unfortunately, constraints are not displayed in full detail. Or am I missing something? I only get the names of the constraints, but not the details like check(Field01 > 0)

    Under Windows I use IBExpert, but this doesn't run under Mac OS X.

    Thank you for your input,
    Mike
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,788
    Rep Power
    349
    Check out SQL Workbench, it's Java based and runs well under MacOS

    http://www.sql-workbench.net/
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2011
    Location
    Munich, Germany
    Posts
    3
    Rep Power
    0
    Hey Shammat,
    Thank you for your response.

    I managed to get SQL Workbench going, but it seems as if it provides the same information like RazorSQL. As for constraints e.g., I cannot gather all the information that has to do with the constraint (mainly the name is provided).
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,788
    Rep Power
    349
    Originally Posted by polarpro
    I managed to get SQL Workbench going, but it seems as if it provides the same information like RazorSQL. As for constraints e.g., I cannot gather all the information that has to do with the constraint (mainly the name is provided).
    It does display the name of the constraint for me, e.g. for the following table
    Code:
    CREATE TABLE CHECK_TEST
    (
       ID  INTEGER
       ,CONSTRAINT CHECK_POSITIVE check (id > 0)
    );
    Maybe you should post that question to the support forum that's listed on the homepage
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2011
    Location
    Munich, Germany
    Posts
    3
    Rep Power
    0
    Yes, it displays the name, but not the actual details that build a constraint (e.g. the calculation that defines allowed values).

    Well, I decided to use PostgreSQL instead. With PostgreSQL comes an interface that lists all I need, and it runs well on a Mac.

    Thanks again for your help;
    Mike

IMN logo majestic logo threadwatch logo seochat tools logo