Class SqlJetSchema

Method Details

• getDb

  public ISqlJetDbHandle getDb()

• getBtree

  public ISqlJetBtree getBtree()

• getTableNames

  public Set<String> getTableNames() throws SqlJetException

  Description copied from interface: ISqlJetSchema

  Get tables names.

  Specified by:

  getTableNames in interface ISqlJetSchema

  Returns:

  tables names.

  Throws:

  SqlJetException

• getTable

  public ISqlJetTableDef getTable(String name) throws SqlJetException

  Description copied from interface: ISqlJetSchema

  Get table definition by name.

  Specified by:

  getTable in interface ISqlJetSchema

  Parameters:

  name - table name

  Returns:

  table definition

  Throws:

  SqlJetException

• getIndexNames

  public Set<String> getIndexNames() throws SqlJetException

  Description copied from interface: ISqlJetSchema

  Get indices names.

  Specified by:

  getIndexNames in interface ISqlJetSchema

  Returns:

  indices names.

  Throws:

  SqlJetException

• getIndex

  public ISqlJetIndexDef getIndex(String name) throws SqlJetException

  Description copied from interface: ISqlJetSchema

  Get index definition by name.

  Specified by:

  getIndex in interface ISqlJetSchema

  Parameters:

  name - index name

  Returns:

  index definition

  Throws:

  SqlJetException

• getIndexes

  public Set<ISqlJetIndexDef> getIndexes(String tableName) throws SqlJetException

  Description copied from interface: ISqlJetSchema

  Get indices related with table.

  Specified by:

  getIndexes in interface ISqlJetSchema

  Parameters:

  tableName - table name

  Returns:

  indices of table

  Throws:

  SqlJetException

• getVirtualTableNames

  public Set<String> getVirtualTableNames() throws SqlJetException

  Specified by:

  getVirtualTableNames in interface ISqlJetSchema

  Returns:

  Set of virtual table names defined in this schema.

  Throws:

  SqlJetException

• getVirtualTable

  public ISqlJetVirtualTableDef getVirtualTable(String name) throws SqlJetException

  Specified by:

  getVirtualTable in interface ISqlJetSchema

  Parameters:

  name -

  Returns:

  definition of the virtual table name.

  Throws:

  SqlJetException

• getView

  public ISqlJetViewDef getView(String name) throws SqlJetException

  Description copied from interface: ISqlJetSchema

  Get view definition by name.

  Specified by:

  getView in interface ISqlJetSchema

  Parameters:

  name - view name

  Returns:

  view definition

  Throws:

  SqlJetException

• getViewNames

  public Set<String> getViewNames() throws SqlJetException

  Specified by:

  getViewNames in interface ISqlJetSchema

  Returns:

  Set of view names defined in this schema.

  Throws:

  SqlJetException

• getTrigger

  public ISqlJetTriggerDef getTrigger(String name) throws SqlJetException

  Description copied from interface: ISqlJetSchema

  Get trigger definition by name.

  Specified by:

  getTrigger in interface ISqlJetSchema

  Parameters:

  name - trigger name

  Returns:

  trigger definition

  Throws:

  SqlJetException

• getTriggerNames

  public Set<String> getTriggerNames() throws SqlJetException

  Specified by:

  getTriggerNames in interface ISqlJetSchema

  Returns:

  Set of trigger names defined in this schema.

  Throws:

  SqlJetException

• toString

  public String toString()

  Overrides:

  toString in class Object

• createTable

  public ISqlJetTableDef createTable(String sql) throws SqlJetException

  Throws:

  SqlJetException

• openSequenceTable

  public ISqlJetBtreeDataTable openSequenceTable() throws SqlJetException

  Throws:

  SqlJetException

• createIndex

  public ISqlJetIndexDef createIndex(String sql) throws SqlJetException

  Throws:

  SqlJetException

• dropTable

  public void dropTable(String tableName) throws SqlJetException

  Throws:

  SqlJetException

• dropIndex

  public void dropIndex(String indexName) throws SqlJetException

  Throws:

  SqlJetException

• alterTable

  public ISqlJetTableDef alterTable(String sql) throws SqlJetException

  Throws:

  SqlJetException

• createVirtualTable

  public ISqlJetVirtualTableDef createVirtualTable(String sql, int page) throws SqlJetException

  Throws:

  SqlJetException

• createView

  public ISqlJetViewDef createView(String sql) throws SqlJetException

  Throws:

  SqlJetException

• isNameReserved

  public boolean isNameReserved(String name)

  Returns true if name is reserved for internal use.

  Parameters:

  name -

  Returns:

  true if name is reserved

• createIndexForVirtualTable

  public ISqlJetIndexDef createIndexForVirtualTable(String virtualTableName, String indexName) throws SqlJetException

  Throws:

  SqlJetException

• dropView

  public void dropView(String viewName) throws SqlJetException

  Throws:

  SqlJetException

• dropTrigger

  public void dropTrigger(String triggerName) throws SqlJetException

  Throws:

  SqlJetException

• createTrigger

  public ISqlJetTriggerDef createTrigger(String sql) throws SqlJetException

  Throws:

  SqlJetException