|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.eclipse.datatools.connectivity.sqm.core.rte.fe.GenericDdlBuilder
org.eclipse.datatools.enablement.sybase.ddl.SybaseDdlBuilder
org.eclipse.datatools.enablement.sybase.asa.ddl.SybaseASADdlBuilder
public class SybaseASADdlBuilder
Field Summary | |
---|---|
static com.ibm.icu.text.DateFormat |
DATE_FORMAT
Used in event schedule formatting |
static com.ibm.icu.text.DateFormat |
TIME_FORMAT
|
Fields inherited from interface org.eclipse.datatools.enablement.sybase.asa.ISybaseASADdlConstants |
---|
AND, ASE, BETWEEN, BLANK, BY, CASE, CHECKSUM, COLLATION, COMPATIBLE, COMPUTE, CONNECT, DATE, DAYS_OF_WEEK, DBSPACE, DECLARELOCALTEMP, DISABLE, ENABLE, ENCRYPTED, EVENT_CONDITION, EVERY, EXISTING, GLOBALTEMPTABLE, GROUP, HANDLER, IDENTIFIED, IGNORE, JCONNECT, JDK, KEY, MEMBERSHIP, MIRROR, MODIFY, NOTTRANSACTIONAL, OFF, ONCOMMITDELETE, ONCOMMITPRESERVE, ONEXCEPTIONRESUME, ORDER, PADDING, PAGE, PASSWORD, PCTFREE, REMOTE, RESPECT, RESULT, SCHEDULE, SERVICE, SIZE, START, SYNTAX_TYPE_LIBRARY_CALL, SYNTAX_TYPE_PROXY, SYNTAX_TYPE_SQLJ, SYNTAX_TYPE_TSQL, SYNTAX_TYPE_WATCOM1, SYNTAX_TYPE_WATCOM2, TEMP_PASSWORD, TIME, USER, VIRTUAL, WHERE |
Fields inherited from interface org.eclipse.datatools.enablement.sybase.ddl.ISybaseDdlConstants |
---|
ALTER_PRIVILEGE, ASC, AT, BEGIN, CAST, CHECKOPTION, CLUSTERED, COLUMN, COMMENT, COMMIT, DATABASE, DELETE_PRIVILEGE, DESC, END, END_IF, EQUAL, EVENT, EXEC_PRIVILEGE, EXISTS, EXTERNAL, EXTERNAL_NAME, FILE, FROM, GO, GO_FOR, GRANT, IF, IN, INOUT, INSERT_PRIVILEGE, IS, JAVA, LOCATOR, LOG, MESSAGE, NONCLUSTERED, OUT, OUTPUT, REFERENCE_PRIVILEGE, REFERENCES_PRIVILEGE, REMOVE, RENAME, REVOKE, SELECT_PRIVILEGE, SEMICOLUMN, SP_RENAME, THEN, TO, UPDATE_PRIVILEGE, WITH_GRANT_OPTION, WITH_RECOMPILE |
Method Summary | |
---|---|
java.lang.String[] |
addCheckConstraint(CheckConstraint constraint,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
Returns the SQL Statement for adding check constraint clause. |
java.lang.String[] |
addForeignKey(ForeignKey foreignKey,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
Returns the SQL Statement for adding foreign key clause. |
java.lang.String[] |
addUniqueConstraint(UniqueConstraint constraint,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
Returns the SQL Statement for adding unique constraint/primary key clause. |
java.lang.String[] |
createAuthorizationId(AuthorizationIdentifier authId,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
GRANT CONNECT TO userid, ... |
java.lang.String[] |
createCatalogs(Catalog catalog,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
java.lang.String[] |
createColumn(Column col,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
ALTER TABLE [ owner.]table-name ADD column-name data-type [ NOT NULL ] [ DEFAULT default-value ] [ column-constraint ... |
java.lang.String |
createComment(SQLObject obj,
boolean quoteIdentifiers,
boolean qualifyNames)
COMMENT ON { COLUMN [ owner.]table-name.column-name | EVENT event-name | FOREIGN KEY [ owner.]table-name.role-name | INDEX [ [ owner.] table.]index-name | JAVA CLASS java-class-name | JAVA JAR java-jar-name | LOGIN integrated_login_id | PROCEDURE [ owner.]procedure-name | SERVICE web-service-name | TABLE [ owner.]table-name | TRIGGER [ [ owner.]tablename.]trigger-name | USER userid | VIEW [ owner.]view-name } IS comment |
java.lang.String |
createComment(SQLObject obj,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean removeComment)
|
java.lang.String[] |
createDatabase(Database database,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
java.lang.String[] |
createDBSpace(SybaseASABaseDBSpace dbSpace,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
CREATE DBSPACE dbspace-name AS filename |
java.lang.String[] |
createEvent(Event event,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
CREATE EVENT event-name [ TYPE event-type [ WHERE trigger-condition [ AND trigger-condition ] ... |
java.lang.String[] |
createIndex(Index index,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
|
java.lang.String[] |
createProcedure(Procedure procedure,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
TSQL: |
java.lang.String[] |
createTrigger(Trigger trigger,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
CREATE TRIGGER trigger-name trigger-time { trigger-event-list | UPDATE OF column-list } [ ORDER integer ] ON table-name [ REFERENCING [ OLD AS old-name ] [ NEW AS new-name ] [ REMOTE AS remote-name ] ] [ FOR EACH { ROW | STATEMENT } ] [ WHEN ( search-condition ) ] compound-statement trigger-time : BEFORE | AFTER | RESOLVE trigger-event-list : trigger-event [ , trigger-event ] trigger-event : DELETE | INSERT | UPDATE |
java.lang.String[] |
createUserDefinedFunction(UserDefinedFunction function,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
CREATE FUNCTION [ owner.]function-name ( [ parameter, ... |
java.lang.String[] |
createUserDefinedType(UserDefinedType udt,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
Returns the SQL Statement for creating domain. |
java.lang.String[] |
createView(ViewTable view,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
CREATE VIEW [ owner.]view-name [ ( column-name, . |
java.lang.String |
dropAuthorizationId(AuthorizationIdentifier authId,
boolean quoteIdentifiers,
boolean qualifyNames)
REVOKE CONNECT FROM userid, ... |
java.lang.String |
dropCheckConstraint(CheckConstraint constraint,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropDatabase(Database db,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropDBSpace(SybaseASABaseDBSpace dbspace,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropEvent(Event event,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropForeignKey(ForeignKey foreignKey,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropFunction(UserDefinedFunction function,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropIndex(Index index,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropProcedure(Procedure procedure,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropTable(BaseTable table,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropTrigger(Trigger trigger,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropUniqueConstraint(UniqueConstraint constraint,
boolean quoteIdentifiers,
boolean qualifyNames)
|
java.lang.String |
dropUserDefinedType(UserDefinedType udt,
boolean quoteIdentifiers,
boolean qualifyNames)
Returns the SQL Statement for droping domain. |
java.lang.String |
dropView(ViewTable view,
boolean quoteIdentifiers,
boolean qualifyNames)
DROP VIEW [ owner.]view-name |
java.lang.String |
getCharacteristics(Routine routine)
|
java.lang.String |
getEventComment(Event obj)
Returns the embeded comment for Event |
java.lang.String |
getEventConditions(java.util.List details)
|
java.lang.String |
getEventHeader(Event event,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax,
boolean debugFormat)
|
java.lang.String |
getEventLocation(boolean fullSyntax,
SybaseASABaseEvent evt)
|
java.lang.String |
getEventSchedule(Schedule schedule)
|
java.lang.String |
getEventScheduleOrType(SybaseASABaseEvent evt)
|
java.lang.String |
getEventSchedules(SybaseASABaseEvent evt)
|
java.lang.String[] |
getEventSource(Event event,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax,
boolean debugFormat)
|
java.lang.String |
getEventStatus(SybaseASABaseEvent evt)
|
java.lang.String |
getFullTriggerEvents(SybaseASABaseTrigger trig)
|
static SybaseASADdlBuilder |
getInstance()
|
java.lang.String |
getRoutineResults(Procedure procedure)
|
int |
getSyntaxType(Procedure routine)
|
java.lang.String |
getTriggerGranularity(SybaseASABaseTrigger trig)
|
java.lang.String |
getTriggerOrder(boolean fullSyntax,
SybaseASABaseTrigger trig)
|
java.lang.String |
getTriggerReference(SybaseASABaseTrigger trig)
|
java.lang.String |
getWatcomParameter(Routine routine,
Parameter p)
|
java.lang.String |
getWatcomParameter(java.lang.String name,
java.lang.String type,
java.lang.String defValue,
java.lang.String mode,
ParameterType paramType)
|
java.lang.String |
getWatcomParameters(Routine routine,
boolean fullSyntax)
Generates watcom style parameters without parenthesis |
java.lang.String[] |
grantPrivilege(Privilege privilege,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
Assemble SQL statement to grant privilege. One thing needs to be pointed out is, a privilege instance can be referenced by an instance of AuthorizationIdentifier (The grantor), it can also be contained by an instance of
AuthorizationIdentifier (The grantee). |
java.lang.String |
parseDaysOfMonth(int daysOfMonth)
|
java.lang.String |
parseDaysOfWeek(int daysOfWeek)
|
Methods inherited from class org.eclipse.datatools.enablement.sybase.ddl.SybaseDdlBuilder |
---|
createTable, createTSQLTrigger, dropCatalog, dropColumn, getDatabaseIdentifier, getIndexKeyColumns, getName, getTriggerBody, getTriggerEvents, getTSQLParameter, getTSQLParameter, revokePrivilege |
Methods inherited from class org.eclipse.datatools.connectivity.sqm.core.rte.fe.GenericDdlBuilder |
---|
addCheckConstraint, addForeignKey, addUniqueConstraint, alterTableAddColumn, createAssertion, createIndex, createProcedure, createSchema, createTable, createTrigger, createUserDefinedFunction, createUserDefinedType, createView, dropAssertion, dropSchema, dropTableConstraint, getEngineeringCallBack, isImplicitConstraint, setEngineeringCallBack |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static final com.ibm.icu.text.DateFormat DATE_FORMAT
public static final com.ibm.icu.text.DateFormat TIME_FORMAT
Method Detail |
---|
public static SybaseASADdlBuilder getInstance()
public java.lang.String[] createCatalogs(Catalog catalog, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
createCatalogs
in class SybaseDdlBuilder
public java.lang.String dropIndex(Index index, boolean quoteIdentifiers, boolean qualifyNames)
dropIndex
in class GenericDdlBuilder
public java.lang.String dropDatabase(Database db, boolean quoteIdentifiers, boolean qualifyNames)
dropDatabase
in class SybaseDdlBuilder
public java.lang.String dropTrigger(Trigger trigger, boolean quoteIdentifiers, boolean qualifyNames)
dropTrigger
in class GenericDdlBuilder
public java.lang.String[] createDatabase(Database database, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
createDatabase
in class SybaseDdlBuilder
public java.lang.String[] createEvent(Event event, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
CREATE EVENT event-name [ TYPE event-type [ WHERE trigger-condition [ AND trigger-condition ] ... ] | SCHEDULE schedule-spec, ... ] [ ENABLE | DISABLE ] [ AT { CONSOLIDATED | REMOTE | ALL } ] [ HANDLER BEGIN ... END ] event-type : BackupEnd | "Connect" | ConnectFailed | DatabaseStart | DBDiskSpace | "Disconnect" | GlobalAutoincrement | GrowDB | GrowLog | GrowTemp | LogDiskSpace | "RAISERROR" | ServerIdle | TempDiskSpace trigger-condition : event_condition( condition-name ) { = | < | > | != | <= | >= } value schedule-spec : [ schedule-name ] { START TIME start-time | BETWEEN start-time AND end-time } [ EVERY period { HOURS | MINUTES | SECONDS } ] [ ON { ( day-of-week, ... ) | ( day-of-month, ... ) } ] [ START DATE start-date ] event-name | schedule-name : identifier day-of-week : string day-of-month | value | period : integer start-time | end-time : time start-date : dateTODO check the format of the ASA debugger
createEvent
in class SybaseDdlBuilder
public java.lang.String[] getEventSource(Event event, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax, boolean debugFormat)
event
- quoteIdentifiers
- qualifyNames
- fullSyntax
- debugFormat
- Whether the generated ddl should be used for debugging
public java.lang.String getEventHeader(Event event, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax, boolean debugFormat)
public java.lang.String getEventStatus(SybaseASABaseEvent evt)
public java.lang.String getEventLocation(boolean fullSyntax, SybaseASABaseEvent evt)
public java.lang.String getEventScheduleOrType(SybaseASABaseEvent evt)
public java.lang.String getEventConditions(java.util.List details)
public java.lang.String[] createProcedure(Procedure procedure, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
TSQL:
CREATE PROCEDURE [owner.]procedure_name [ [ ( ] @parameter_name data-type [ = default ] [ OUTPUT ], ... [ ) ] ] [ WITH RECOMPILE ] AS statement-list
Watcom1:
CREATE PROCEDURE [ owner.]procedure-name ( [ parameter, ... ] ) { [ RESULT ( result-column, ... ) ] [ ON EXCEPTION RESUME ] compound-statement | AT location-string | EXTERNAL NAME library-call | [ DYNAMIC RESULT SETS integer-expression ] [ EXTERNAL NAME java-call LANGUAGE JAVA ] }
Watcom2:
CREATE PROCEDURE [ owner.]procedure-name ( [ parameter, ... ] ) compound-statement
createProcedure
in class SybaseDdlBuilder
public java.lang.String getRoutineResults(Procedure procedure)
public java.lang.String[] createUserDefinedFunction(UserDefinedFunction function, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
CREATE FUNCTION [ owner.]function-name ( [ parameter, ... ] ) RETURNS data-type routine-characteristics { compound-statement | AS tsql-compound-statement | external-name } parameter : [ IN ] parameter-name data-type routine-characteristics ON EXCEPTION RESUME | [ NOT ] DETERMINISTIC tsql-compound-statement: sql-statement sql-statement ... external-name: EXTERNAL NAME library-call | EXTERNAL NAME java-call LANGUAGE JAVA library-call : '[operating-system:]function-name@library; ...' operating-system : Windows95 | WindowsNT | NetWare | UNIX java-call : '[package-name.]class-name.method-name method-signature' method-signature : ([field-descriptor, ... ]) return-descriptor field-descriptor | return-descriptor : Z | B | S | I | J | F | D | C | V | [descriptor | Lclass-name;
createUserDefinedFunction
in class SybaseDdlBuilder
public java.lang.String getCharacteristics(Routine routine)
public java.lang.String[] createTrigger(Trigger trigger, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
CREATE TRIGGER trigger-name trigger-time { trigger-event-list | UPDATE OF column-list } [ ORDER integer ] ON table-name [ REFERENCING [ OLD AS old-name ] [ NEW AS new-name ] [ REMOTE AS remote-name ] ] [ FOR EACH { ROW | STATEMENT } ] [ WHEN ( search-condition ) ] compound-statement trigger-time : BEFORE | AFTER | RESOLVE trigger-event-list : trigger-event [ , trigger-event ] trigger-event : DELETE | INSERT | UPDATETODO TSQL
createTrigger
in class SybaseDdlBuilder
public java.lang.String getTriggerReference(SybaseASABaseTrigger trig)
public java.lang.String getTriggerGranularity(SybaseASABaseTrigger trig)
public java.lang.String getTriggerOrder(boolean fullSyntax, SybaseASABaseTrigger trig)
public java.lang.String getFullTriggerEvents(SybaseASABaseTrigger trig)
public java.lang.String[] createUserDefinedType(UserDefinedType udt, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
See following SQL Syntax:
CREATE { DOMAIN | DATATYPE } [ AS ] domain-name data-type [ [ NOT ] NULL ] [ DEFAULT default-value ] [ CHECK ( condition ) ]
createUserDefinedType
in class SybaseDdlBuilder
asaUDT
- quoteIdentifiers
- qualifyNames
-
public java.lang.String[] grantPrivilege(Privilege privilege, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
SybaseDdlBuilder
AuthorizationIdentifier
(The grantor), it can also be contained by an instance of
AuthorizationIdentifier
(The grantee).
In this case, to avoid generating a same grant statement two times, we only generate the statement for a contained privilege.
Syntax:
Adaptive Server Anywhere 9.x
GRANT { ALL [ PRIVILEGES ], ALTER, DELETE, INSERT, REFERENCES [ ( column-name, ... ) ], SELECT [ ( column-name, ... ) ], UPDATE [ ( column-name, ... ) ], } ON [ owner.]table-name TO userid, ... [ WITH GRANT OPTION ] [ FROM userid ]
GRANT EXECUTE ON [ owner.]procedure-name TO userid, ...
Adaptive Server Enterprise 12.5.x & 15.x
grant {all [privileges]| permission_list} on { table_name [(column_list)] | view_name[(column_list)] | stored_procedure_name} to {public | name_list | role_name} [with grant option]
Object permission_list ------------------------------------------------------ Table select, insert, delete, update, references View select, insert, delete, update Column select, update, references Stored procedure executeTODO: For ASE15, there're new types of permissions, I'll do research to find out if we should support them. The "[FROM userid]" sub clause won't be used here.
grantPrivilege
in class SybaseDdlBuilder
privilege
- the privilege instancequoteIdentifiers
- the status of "quoted_identifier"qualifyNames
- if qulified name should be usedpublic java.lang.String[] createView(ViewTable view, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
CREATE VIEW [ owner.]view-name [ ( column-name, . . . ) ] AS select-statement [ WITH CHECK OPTION ]
createView
in class SybaseDdlBuilder
public java.lang.String createComment(SQLObject obj, boolean quoteIdentifiers, boolean qualifyNames)
COMMENT ON { COLUMN [ owner.]table-name.column-name | EVENT event-name | FOREIGN KEY [ owner.]table-name.role-name | INDEX [ [ owner.] table.]index-name | JAVA CLASS java-class-name | JAVA JAR java-jar-name | LOGIN integrated_login_id | PROCEDURE [ owner.]procedure-name | SERVICE web-service-name | TABLE [ owner.]table-name | TRIGGER [ [ owner.]tablename.]trigger-name | USER userid | VIEW [ owner.]view-name } IS commentFor ASA, when creating a view, there may be comments on the view or its columns, so COMMENT ON statement is needed for the view creating.
public java.lang.String createComment(SQLObject obj, boolean quoteIdentifiers, boolean qualifyNames, boolean removeComment)
obj
- quoteIdentifiers
- qualifyNames
- removeComment
- whether to create sql statement to remove the comment if it's null.
public java.lang.String getEventComment(Event obj)
obj
-
public java.lang.String[] createIndex(Index index, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
createIndex
in class SybaseDdlBuilder
public java.lang.String[] addUniqueConstraint(UniqueConstraint constraint, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
See following SQL Syntax:
alter table [[database.][owner].table_name add CONSTRAINT constraint-name ] { UNIQUE ( column-name, . . . ) | PRIMARY KEY [ CLUSTERED ] ( column-name, . . . )
addUniqueConstraint
in class SybaseDdlBuilder
constraint
- quoteIdentifiers
- qualifyNames
- fullSyntax
-
public java.lang.String[] addForeignKey(ForeignKey foreignKey, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
See following SQL Syntax:
alter table [[database.][owner].table_name add {[constraint constraint_name] [ NOT NULL ] FOREIGN KEY [ role-name ] [ (column-name, . . . ) ] REFERENCES table-name [ (column-name, . . . ) ] [ CLUSTERED ] [ actions ] [ CHECK ON COMMIT ] actions : [ ON UPDATE action ] [ ON DELETE action ] action : CASCADE | SET NULL | SET DEFAULT | RESTRICT
addForeignKey
in class SybaseDdlBuilder
constraint
- quoteIdentifiers
- qualifyNames
- fullSyntax
-
public java.lang.String[] createColumn(Column col, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
ALTER TABLE [ owner.]table-name ADD column-name data-type [ NOT NULL ] [ DEFAULT default-value ] [ column-constraint ... ]
createColumn
in class SybaseDdlBuilder
public java.lang.String[] createDBSpace(SybaseASABaseDBSpace dbSpace, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
CREATE DBSPACE dbspace-name AS filename
public java.lang.String[] createAuthorizationId(AuthorizationIdentifier authId, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
GRANT CONNECT TO userid, ... IDENTIFIED BY password, ... ; GRANT { GROUP, MEMBERSHIP IN GROUP userid, ..., [ RESOURCE | ALL ] } TO userid, ...
createAuthorizationId
in class SybaseDdlBuilder
public java.lang.String dropEvent(Event event, boolean quoteIdentifiers, boolean qualifyNames)
dropEvent
in class SybaseDdlBuilder
public java.lang.String dropProcedure(Procedure procedure, boolean quoteIdentifiers, boolean qualifyNames)
dropProcedure
in class SybaseDdlBuilder
public java.lang.String dropFunction(UserDefinedFunction function, boolean quoteIdentifiers, boolean qualifyNames)
dropFunction
in class SybaseDdlBuilder
public java.lang.String dropTable(BaseTable table, boolean quoteIdentifiers, boolean qualifyNames)
dropTable
in class GenericDdlBuilder
public java.lang.String dropView(ViewTable view, boolean quoteIdentifiers, boolean qualifyNames)
SybaseDdlBuilder
DROP VIEW [ owner.]view-name
dropView
in class SybaseDdlBuilder
public java.lang.String dropForeignKey(ForeignKey foreignKey, boolean quoteIdentifiers, boolean qualifyNames)
dropForeignKey
in class SybaseDdlBuilder
public java.lang.String dropCheckConstraint(CheckConstraint constraint, boolean quoteIdentifiers, boolean qualifyNames)
dropCheckConstraint
in class SybaseDdlBuilder
public java.lang.String dropUniqueConstraint(UniqueConstraint constraint, boolean quoteIdentifiers, boolean qualifyNames)
dropUniqueConstraint
in class SybaseDdlBuilder
public java.lang.String dropUserDefinedType(UserDefinedType udt, boolean quoteIdentifiers, boolean qualifyNames)
See following SQL Syntax:
DROP { DATATYPE | DOMAIN } datatype-name
dropUserDefinedType
in class SybaseDdlBuilder
asaUDT
- quoteIdentifiers
- qualifyNames
-
public java.lang.String dropDBSpace(SybaseASABaseDBSpace dbspace, boolean quoteIdentifiers, boolean qualifyNames)
dbspace
- quoteIdentifiers
- qualifyNames
-
public java.lang.String dropAuthorizationId(AuthorizationIdentifier authId, boolean quoteIdentifiers, boolean qualifyNames)
REVOKE CONNECT FROM userid, ...
dropAuthorizationId
in class SybaseDdlBuilder
public java.lang.String getWatcomParameters(Routine routine, boolean fullSyntax)
parameter_mode parameter-name data-type [ DEFAULT expression ] | SQLCODE | SQLSTATE
public java.lang.String getWatcomParameter(Routine routine, Parameter p)
public java.lang.String getWatcomParameter(java.lang.String name, java.lang.String type, java.lang.String defValue, java.lang.String mode, ParameterType paramType)
public int getSyntaxType(Procedure routine)
public java.lang.String getEventSchedules(SybaseASABaseEvent evt)
public java.lang.String getEventSchedule(Schedule schedule)
public java.lang.String parseDaysOfWeek(int daysOfWeek)
public java.lang.String parseDaysOfMonth(int daysOfMonth)
public java.lang.String[] addCheckConstraint(CheckConstraint constraint, boolean quoteIdentifiers, boolean qualifyNames, boolean fullSyntax)
SybaseDdlBuilder
See following SQL Syntax:
alter table [[database.][owner].table_name add {[constraint constraint_name] check (search_condition)}
addCheckConstraint
in class SybaseDdlBuilder
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |