| Method Summary |
|
| public boolean | canPasteTo(IDatabaseObjectInfo info)
|
| public String[] | getAddPrimaryKeySQL(String pkName, TableColumnInfo[] columnNames, 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. |
| 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 test alter column foo set 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.
alter table tableName drop column columnName cascade
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()
|