|
||||||||||
| 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 : date
TODO 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 SybaseDdlBuilderpublic 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 SybaseDdlBuilderpublic 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 | UPDATE
TODO TSQL
createTrigger in class SybaseDdlBuilderpublic 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 SybaseDdlBuilderasaUDT - quoteIdentifiers - qualifyNames -
public java.lang.String[] grantPrivilege(Privilege privilege,
boolean quoteIdentifiers,
boolean qualifyNames,
boolean fullSyntax)
SybaseDdlBuilderAuthorizationIdentifier (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 execute
TODO: 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 SybaseDdlBuilderprivilege - the privilege instancequoteIdentifiers - the status of "quoted_identifier"qualifyNames - if qulified name should be used
public 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 comment
For 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 SybaseDdlBuilderconstraint - 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 SybaseDdlBuilderconstraint - 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 SybaseDdlBuilderasaUDT - 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)
SybaseDdlBuilderSee 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 | |||||||||