Here you can find the source of tableExists(Connection connection, String tableName)
public static boolean tableExists(Connection connection, String tableName) throws SQLException
//package com.java2s; /*//ww w. j a v a 2s .c om * This file is part of Alpine. * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. * * Copyright (c) Steve Springett. All Rights Reserved. */ import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; public class Main { public static boolean tableExists(Connection connection, String tableName) throws SQLException { for (String s : getTableNames(connection)) { if (s.equals(tableName)) { return true; } } return false; } public static ArrayList<String> getTableNames(Connection connection) throws SQLException { ArrayList<String> tableNames = new ArrayList<>(); DatabaseMetaData databaseMetaData = connection.getMetaData(); ResultSet resultSet = databaseMetaData.getTables(null, null, null, new String[] { "TABLE" }); while (resultSet.next()) { tableNames.add(resultSet.getString("TABLE_NAME")); } return tableNames; } }