| Method Summary |
|
| public boolean | canPasteTo(IDatabaseObjectInfo info)
|
| public String[] | getAddPrimaryKeySQL(String pkName, TableColumnInfo[] columns, ITableInfo ti)
Returns the SQL that forms the command to add a primary key to the
specified table composed of the given column names. |
| public String[] | getColumnAddSQL(TableColumnInfo info)
Returns the SQL statement to use to add a column to the specified table
using the information about the new column specified by info.
ALTER TABLE tableName ADD COLUMN columnName type
alter table tableName alter column columnName type default defVal
alter table tableName alter column columnName type not null
Parameters:
info - information about the new column such as type, name, etc. |
| public String | getColumnCommentAlterSQL(TableColumnInfo info)
Returns the SQL statement to use to add a comment to the specified
column of the specified table. |
| public String | getColumnDefaultAlterSQL(TableColumnInfo info)
Returns the SQL command to change the specified column's default value
alter table test2 alter column mycol char(10) default 'foo'
Parameters:
info - the column to modify and it's default value. |
| public String | getColumnDropSQL(String tableName, String columnName)
Returns the SQL that forms the command to drop the specified colum in the
specified table.
Parameters:
tableName - the name of the table that has the column
Parameters:
columnName - the name of the column to drop.
throws:
UnsupportedOperationException - if the database doesn't support dropping columns. |
| public int | getColumnLength(int columnSize, int dataType)
|
| public String | getColumnNameAlterSQL(TableColumnInfo from, TableColumnInfo to)
Returns the SQL that is used to change the column name. |
| public String | getColumnNullableAlterSQL(TableColumnInfo info)
|
| public List<String> | getColumnTypeAlterSQL(TableColumnInfo from, TableColumnInfo to)
Returns the SQL that is used to change the column type. |
| public List<String> | getCreateTableSQL(List<ITableInfo> tables, ISQLDatabaseMetaData md, CreateScriptPreferences prefs, boolean isJdbcOdbc)
Returns the SQL command to create the specified table.
Parameters:
tables - the tables to get create statements for
Parameters:
md - the metadata from the ISession
Parameters:
prefs - preferences about how the resultant SQL commands should be formed.
Parameters:
isJdbcOdbc - whether or not the connection is via JDBC-ODBC bridge. |
| public String | getDisplayName()
The string which identifies this dialect in the dialect chooser. |
| public String | getDropForeignKeySQL(String fkName, String tableName)
Returns the SQL command to drop the specified table's foreign key
constraint. |
| public String | getDropPrimaryKeySQL(String pkName, String tableName)
Returns the SQL command to drop the specified table's primary key. |
| public String | getLengthFunction(int dataType)
|
| public String | getMaxFunction()
|
| public int | getMaxPrecision(int dataType)
|
| public int | getMaxScale(int dataType)
|
| public int | getPrecisionDigits(int columnSize, int dataType)
|
| public List<String> | getTableDropSQL(ITableInfo iTableInfo, boolean cascadeConstraints, boolean isMaterializedView)
Returns the SQL that forms the command to drop the specified table. |
| public boolean | supportsAlterColumnDefault()
Returns a boolean value indicating whether or not this database dialect
supports changing a column's default value. |
| public boolean | supportsAlterColumnNull()
Returns a boolean value indicating whether or not this database dialect
supports changing a column from null to not-null and vice versa. |
| public boolean | supportsAlterColumnType()
Returns a boolean value indicating whether or not this dialect supports
modifying a columns type. |
| public boolean | supportsColumnComment()
Returns a boolean value indicating whether or not this dialect supports
adding comments to columns. |
| public boolean | supportsDropColumn()
Returns a boolean value indicating whether or not this database dialect
supports dropping columns from tables. |
| public boolean | supportsProduct(String databaseProductName, String databaseProductVersion)
Returns boolean value indicating whether or not this dialect supports the
specified database product/version. |
| public boolean | supportsRenameColumn()
Returns a boolean value indicating whether or not this database dialect
supports renaming columns. |
| public boolean | supportsSchemasInTableDefinition()
|