Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Posts
    54

    Unanswered: SQL Statment for table def

    using sql statements, is there a way for me to know the
    structure of the table... like what field is the PK, what are
    the data type of this field, etc.

  2. #2
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    query user_tables and user_constraints

    constraint_type can be P - primary key, R - foreign key, U - unique key or C - check constraint
    There are 10 types of people in the world, those that know Binary and those that don't.

  3. #3
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Try this:


    (Don't forget to look at the REM header & pay homage to the original author - btw, it wasn't me!)
    Attached Files Attached Files
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  4. #4
    Join Date
    Oct 2004
    Posts
    54
    thanks for all your help.....

Posting Permissions

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