Package overit.geocall.sql

Class SQLServerMetadata

java.lang.Object

overit.geocall.sql.SQLServerMetadata

public class SQLServerMetadata
extends Object

Comprehensive information about the Microsoft SQL Server tables and table-spaces.

Constructor Summary

Constructors

Constructor	Description
SQLServerMetadata()

Method Summary

Modifier and Type	Method	Description
String	getDefaultTableSpace()
default List<String>	getTables(Connection conn)	Retrieve the whole tables
List<String>	getTableSpaces(Connection conn)
boolean	isTableDefined(Connection conn, String table)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

SQLServerMetadata

public SQLServerMetadata()

Method Details

isTableDefined

public boolean isTableDefined(Connection conn,
 String table)
                       throws SQLException

Throws:

SQLException

getTableSpaces

public List<String> getTableSpaces(Connection conn)

getDefaultTableSpace

public String getDefaultTableSpace()

getTables

default List<String> getTables(Connection conn)
                        throws SQLException

Retrieve the whole tables

Parameters:

conn - connection used to retrieve the info

Returns:

a list of all DB tables or empty collection if there's none

Throws:

SQLException