Java JDBC Database Metadata printExistingTables(Connection conn)

Description

print Existing Tables

License

Open Source License

Declaration

public static void printExistingTables(Connection conn) throws SQLException 

Method Source Code

//package com.java2s;
//License from project: Open Source License 

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

public class Main {
    public static void printExistingTables(Connection conn) throws SQLException {
        DatabaseMetaData dbmd = conn.getMetaData();
        System.out.println("********************************************");
        ResultSet rs = dbmd.getTables(null, null, null, null);
        while (rs.next()) {
            System.out.println(rs.getString("TABLE_NAME"));
        }//from  w  w  w.  j  a va 2s  . com
        System.out.println("********************************************");
    }
}

Related

1. isIdGenerated(DatabaseMetaData metaData)
2. isMysql(DatabaseMetaData metadata)
3. isOracleForSid(DatabaseMetaData metadata, String oracleProduct)
4. isSybase(DatabaseMetaData metadata)
5. isSybaseDb(DatabaseMetaData metaData)
6. printMetaData(Connection con)
7. printTableExistence(String name, Connection conn)
8. sequenceExists(String seqName, Connection conn)
9. tableExists(Connection con, String table)