Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Red face Unanswered: Existing Tables?

    I am trying to build a simple JDBC program to create and manipulate databases. What I need to know is how to check before creating a table if the table alreay exists and if its blank or has records. Does anyone have any clue how to do this? I have been searching for days.

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320

    Re: Existing Tables?

    Originally posted by LacyH527
    I am trying to build a simple JDBC program to create and manipulate databases. What I need to know is how to check before creating a table if the table alreay exists and if its blank or has records. Does anyone have any clue how to do this? I have been searching for days.
    You could test the table with tables in database metadate

    Code:
    Resultset getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

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