Java JDBC Database Metadata tableExists(DatabaseMetaData metaData, String tableName)

Description

table Exists

License

Open Source License

Declaration

public static boolean tableExists(DatabaseMetaData metaData,
            String tableName) throws SQLException 

Method Source Code

//package com.java2s;
/*/*from  w  ww  . j a v  a 2 s.  co  m*/
 * Artifactory is a binaries repository manager.
 * Copyright (C) 2012 JFrog Ltd.
 *
 * Artifactory is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Lesser General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * Artifactory is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with Artifactory.  If not, see <http://www.gnu.org/licenses/>.
 */

import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.sql.SQLException;

public class Main {
    public static boolean tableExists(DatabaseMetaData metaData,
            String tableName) throws SQLException {
        boolean schemaExists;
        if (metaData.storesLowerCaseIdentifiers()) {
            tableName = tableName.toLowerCase();
        } else if (metaData.storesUpperCaseIdentifiers()) {
            tableName = tableName.toUpperCase();
        }
        try (ResultSet rs = metaData.getTables(null, null, tableName,
                new String[] { "TABLE" })) {
            schemaExists = rs.next();
        }
        return schemaExists;
    }
}

Related

1. printTableExistence(String name, Connection conn)
2. sequenceExists(String seqName, Connection conn)
3. tableExists(Connection con, String table)
4. tableExists(Connection connection, String tableName)
5. tableExists(Connection connection, String tableName)
6. tableExists(String tableName, Connection conn)
7. tableExists(String tableName, DatabaseMetaData dbm)
8. tableIsAccesable(Connection conn, String TableName)