SQLJet Home

org.tmatesoft.sqljet.core.schema
Interface ISqlJetTableDef


public interface ISqlJetTableDef

Table Definition.

Author:
TMate Software Ltd., Dmitry Stadnik (dtrace@seznam.cz)

Method Summary
 ISqlJetColumnDef getColumn(java.lang.String name)
          Returns column definition with a given name or null if there is no such definition.
 int getColumnNumber(java.lang.String name)
          Returns position of the specified column within the table definition.
 java.util.List<ISqlJetColumnDef> getColumns()
          Definitions of table columns.
 java.util.List<ISqlJetTableConstraint> getConstraints()
          Returns all table constraints.
 java.lang.String getName()
          Returns table name.
 java.lang.String getPrimaryKeyIndexName()
           
 boolean isAutoincremented()
          Returns true if primary key has 'autoincrement' keyword.
 boolean isRowIdPrimaryKey()
          Returns true if primary key definition allows rowid to be used as primary key column.
 boolean isTemporary()
          True if table was created temporarily.
 java.lang.String toSQL()
           
 

Method Detail

getName

java.lang.String getName()
Returns table name.


isTemporary

boolean isTemporary()
True if table was created temporarily.


getColumns

java.util.List<ISqlJetColumnDef> getColumns()
Definitions of table columns.


getColumn

ISqlJetColumnDef getColumn(java.lang.String name)
Returns column definition with a given name or null if there is no such definition.


getColumnNumber

int getColumnNumber(java.lang.String name)
Returns position of the specified column within the table definition.


getConstraints

java.util.List<ISqlJetTableConstraint> getConstraints()
Returns all table constraints.


isRowIdPrimaryKey

boolean isRowIdPrimaryKey()
Returns true if primary key definition allows rowid to be used as primary key column. In practice this means that the table has primary key that is based in a single column of type 'integer'.


isAutoincremented

boolean isAutoincremented()
Returns true if primary key has 'autoincrement' keyword.


getPrimaryKeyIndexName

java.lang.String getPrimaryKeyIndexName()
Returns:
name of the primary key index.

toSQL

java.lang.String toSQL()
Returns:
SQL representation of this table schema definition.

SQLJet Home

Copyright © 2009-2010 TMate Software Ltd. All Rights Reserved.