org.eclipse.datatools.enablement.msft.internal.sqlserver.ddl
Class SqlServerDdlBuilder

java.lang.Object
  org.eclipse.datatools.connectivity.sqm.core.rte.fe.GenericDdlBuilder
      org.eclipse.datatools.enablement.msft.internal.sqlserver.ddl.SqlServerDdlBuilder

public class SqlServerDdlBuilder
extends GenericDdlBuilder

Constructor Summary

SqlServerDdlBuilder()

Method Summary

java.lang.String	addForeignKey(ForeignKey foreignKey, boolean quoteIdentifiers, boolean qualifyNames)
java.lang.String	addUniqueConstraint(Index constraint, boolean quoteIdentifiers, boolean qualifyNames)
java.lang.String	asOnOff(boolean flag)
void	clear()
java.lang.String	createIndex(Index index, boolean quoteIdentifiers, boolean qualifyNames)
java.lang.String	createProcedure(Procedure procedure, boolean quoteIdentifiers, boolean qualifyNames)
java.lang.String[]	createSetOptions(SQLObject[] elements) http://msdn.microsoft.com/en-us/library/ms191203.aspx http://msdn.microsoft.com/en-us/library/ms190707.aspx http://msdn.microsoft.com/en-us/library/ms190356.aspx
java.lang.String	createTable(BaseTable table, boolean quoteIdentifiers, boolean qualifyNames)
java.lang.String[]	createUnsetOptions(SQLObject[] elements)
java.lang.String	createUserDefinedType(UserDefinedType type, boolean quoteIdentifiers, boolean qualifyNames)
java.lang.String	dropIndex(Index index, boolean quoteIdentifiers, boolean qualifyNames)
java.lang.String	dropTable(BaseTable table, boolean quoteIdentifiers, boolean qualifyNames)
java.lang.String	dropTableConstraint(Index uniqueIndex, boolean quoteIdentifiers, boolean qualifyNames)
java.lang.String	dropTableConstraint(TableConstraint constraint, boolean quoteIdentifiers, boolean qualifyNames)
ReferenceConstraint	findConstraintByIndex(Index index)
Index	findIndexByConstraint(ReferenceConstraint constraint)
java.lang.String	generateIndexOptions(Index index) http://msdn.microsoft.com/en-us/library/ms188783.aspx ::= { PAD_INDEX = { ON | OFF } | FILLFACTOR = fillfactor | SORT_IN_TEMPDB = { ON | OFF } | IGNORE_DUP_KEY = { ON | OFF } | STATISTICS_NORECOMPUTE = { ON | OFF } | DROP_EXISTING = { ON | OFF } | ONLINE = { ON | OFF } | ALLOW_ROW_LOCKS = { ON | OFF } | ALLOW_PAGE_LOCKS = { ON | OFF } | MAXDOP = max_degree_of_parallelism }
void	setElements(java.util.Set elements)

Methods inherited from class org.eclipse.datatools.connectivity.sqm.core.rte.fe.GenericDdlBuilder

addCheckConstraint, addUniqueConstraint, alterTableAddColumn, createAssertion, createSchema, createTrigger, createUserDefinedFunction, createView, dropAssertion, dropFunction, dropProcedure, dropSchema, dropTrigger, dropUserDefinedType, dropView, getEngineeringCallBack, isImplicitConstraint, setEngineeringCallBack

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SqlServerDdlBuilder

public SqlServerDdlBuilder()

Method Detail

createTable

public java.lang.String createTable(BaseTable table,
                                    boolean quoteIdentifiers,
                                    boolean qualifyNames)

Overrides:

createTable in class GenericDdlBuilder

createProcedure

public java.lang.String createProcedure(Procedure procedure,
                                        boolean quoteIdentifiers,
                                        boolean qualifyNames)

Overrides:

createProcedure in class GenericDdlBuilder

dropIndex

public java.lang.String dropIndex(Index index,
                                  boolean quoteIdentifiers,
                                  boolean qualifyNames)

Overrides:

dropIndex in class GenericDdlBuilder

createIndex

public java.lang.String createIndex(Index index,
                                    boolean quoteIdentifiers,
                                    boolean qualifyNames)

Overrides:

createIndex in class GenericDdlBuilder

generateIndexOptions

public java.lang.String generateIndexOptions(Index index)

http://msdn.microsoft.com/en-us/library/ms188783.aspx ::= { PAD_INDEX = { ON | OFF } | FILLFACTOR = fillfactor | SORT_IN_TEMPDB = { ON | OFF } | IGNORE_DUP_KEY = { ON | OFF } | STATISTICS_NORECOMPUTE = { ON | OFF } | DROP_EXISTING = { ON | OFF } | ONLINE = { ON | OFF } | ALLOW_ROW_LOCKS = { ON | OFF } | ALLOW_PAGE_LOCKS = { ON | OFF } | MAXDOP = max_degree_of_parallelism }

asOnOff

public final java.lang.String asOnOff(boolean flag)

setElements

public void setElements(java.util.Set elements)

clear

public final void clear()

findConstraintByIndex

public ReferenceConstraint findConstraintByIndex(Index index)

findIndexByConstraint

public Index findIndexByConstraint(ReferenceConstraint constraint)

createUserDefinedType

public java.lang.String createUserDefinedType(UserDefinedType type,
                                              boolean quoteIdentifiers,
                                              boolean qualifyNames)

Overrides:

createUserDefinedType in class GenericDdlBuilder

addForeignKey

public java.lang.String addForeignKey(ForeignKey foreignKey,
                                      boolean quoteIdentifiers,
                                      boolean qualifyNames)

Overrides:

addForeignKey in class GenericDdlBuilder

addUniqueConstraint

public java.lang.String addUniqueConstraint(Index constraint,
                                            boolean quoteIdentifiers,
                                            boolean qualifyNames)

dropTable

public java.lang.String dropTable(BaseTable table,
                                  boolean quoteIdentifiers,
                                  boolean qualifyNames)

Overrides:

dropTable in class GenericDdlBuilder

dropTableConstraint

public java.lang.String dropTableConstraint(Index uniqueIndex,
                                            boolean quoteIdentifiers,
                                            boolean qualifyNames)

dropTableConstraint

public java.lang.String dropTableConstraint(TableConstraint constraint,
                                            boolean quoteIdentifiers,
                                            boolean qualifyNames)

Overrides:

dropTableConstraint in class GenericDdlBuilder

createSetOptions

public java.lang.String[] createSetOptions(SQLObject[] elements)

http://msdn.microsoft.com/en-us/library/ms191203.aspx http://msdn.microsoft.com/en-us/library/ms190707.aspx http://msdn.microsoft.com/en-us/library/ms190356.aspx

createUnsetOptions

public java.lang.String[] createUnsetOptions(SQLObject[] elements)