Java SQL Table getTables(Connection connection)

Description

get Tables

License

Apache License

Declaration

public static String[] getTables(Connection connection) throws Exception 

Method Source Code

//package com.java2s;
/* //from  w  ww .j  a va2  s.  c  o  m
 * Copyright 2012-2017 qifu of copyright Chen Xin Nien
 * 
 * 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.
 * 
 * -----------------------------------------------------------------------
 * 
 * author:    Chen Xin Nien
 * contact: chen.xin.nien@gmail.com
 * 
 */

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;

import java.util.ArrayList;

import java.util.List;

public class Main {
    public static String[] getTables(Connection connection) throws Exception {
        DatabaseMetaData metaData = connection.getMetaData();
        String[] types = { "TABLE" };
        ResultSet rs = metaData.getTables(null, null, "%", types);
        List<String> tables = new ArrayList<String>();
        while (rs.next()) {
            tables.add(rs.getString("TABLE_NAME"));
        }
        String[] names = new String[tables.size()];
        tables.toArray(names);
        return names;
    }
}

Related

1. getTableList(Connection connection)
2. getTableName(String sql)
3. getTableNames(Connection conn)
4. getTableNames(Connection conn)
5. getTables(Connection conn)
6. getTables(Connection connection)
7. getTables(Connection connection)
8. getTablesFromDatabase(Connection conn)
9. getTableSize(Connection conn, String tableName)