| java.lang.Object com.sqlmagic.tinysql.tinySQL com.sqlmagic.tinysql.textFile
AlterTableAddCol | void AlterTableAddCol(String table_name, Vector v) throws IOException, tinySQLException(Code) | | Creates new Columns in table_name, given a vector of
column definition (tsColumn) arrays.
ALTER TABLE table [ * ] ADD [ COLUMN ] column type
Parameters: table_name - the name of the table Parameters: v - a Vector containing arrays of column definitions. See Also: tinySQL.AlterTableAddCol |
AlterTableDropCol | void AlterTableDropCol(String table_name, Vector v) throws IOException, tinySQLException(Code) | | Deletes Columns from table_name, given a vector of
column definition (tsColumn) arrays.
ALTER TABLE table DROP [ COLUMN ] column { RESTRICT | CASCADE }
Parameters: table_name - the name of the table Parameters: v - a Vector containing arrays of column definitions. See Also: tinySQL.CreateTable |
AlterTableRenameCol | void AlterTableRenameCol(String table_name, String oldName, String newName) throws tinySQLException(Code) | | Changes the name of a column
ALTER TABLE table [ * ] RENAME [ COLUMN ] TO [NEW_COLUMN]
|
CreateTable | void CreateTable(String table_name, Vector v) throws IOException, tinySQLException(Code) | | Creates a table given the name and a vector of
column definition (tsColumn) arrays.
Parameters: table_name - the name of the table Parameters: v - a Vector containing arrays of column definitions. See Also: tinySQL.CreateTable |
Methods inherited from com.sqlmagic.tinysql.tinySQL | abstract void AlterTableAddCol(String tableName, Vector v) throws IOException, tinySQLException(Code)(Java Doc) abstract void AlterTableDropCol(String tableName, Vector v) throws IOException, tinySQLException(Code)(Java Doc) abstract void AlterTableRenameCol(String tableName, String oldColumnName, String newColumnName) throws tinySQLException(Code)(Java Doc) abstract void CreateTable(String tableName, Vector v) throws IOException, tinySQLException(Code)(Java Doc) abstract void DropTable(String tableName) throws tinySQLException(Code)(Java Doc) protected tsResultSet SelectStatement(Hashtable t, Vector c, tinySQLWhere w, String ot, boolean distinct, Object stmt) throws tinySQLException(Code)(Java Doc) protected void contSelectStatement(tsResultSet jrs) throws tinySQLException(Code)(Java Doc) abstract tinySQLTable getTable(String tableName) throws tinySQLException(Code)(Java Doc) protected tsResultSet sql(Object s) throws tinySQLException(Code)(Java Doc) public tsResultSet sqlexec() throws tinySQLException(Code)(Java Doc) public tsResultSet sqlexec(tinySQLStatement s) throws tinySQLException(Code)(Java Doc) public tsResultSet sqlexec(tinySQLPreparedStatement s) throws tinySQLException(Code)(Java Doc)
|
|
|