com.northconcepts.datapipeline.sql.h2

Class DropTableConstraint

java.lang.Object

com.northconcepts.datapipeline.jdbc.sql.SqlPart

com.northconcepts.datapipeline.sql.h2.H2SqlPart

com.northconcepts.datapipeline.sql.h2.DropTableConstraint

public class DropTableConstraint
extends H2SqlPart

Generates a ALTER TABLE...DROP CONSTRAINT statement for H2.

Sample Generated SQL:

ALTER TABLE person DROP CONSTRAINT email_check

Constructor Summary

Constructors

Constructor and Description
DropTableConstraint()
DropTableConstraint(String tableName, String constraintName) Constructs a DropTableConstraint with the specified table and constraint names.

Method Summary

Modifier and Type	Method and Description
void	collectSqlFragment(CodeWriter writer)
String	getConstraintName() Returns the constraint name.
String	getTableName() Returns the table name.
DropTableConstraint	setConstraintName(String constraintName) Sets the constraint name.
DropTableConstraint	setPretty(boolean pretty)
DropTableConstraint	setTableName(String tableName) Sets the table name.

Methods inherited from class com.northconcepts.datapipeline.sql.h2.H2SqlPart

escapeKeyword, placeBackTicks

Methods inherited from class com.northconcepts.datapipeline.jdbc.sql.SqlPart

collectParameterValues, getParameterValues, getSqlFragment, isPretty, printSqlParts, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

DropTableConstraint

public DropTableConstraint()

DropTableConstraint

public DropTableConstraint(String tableName,
                           String constraintName)

Constructs a DropTableConstraint with the specified table and constraint names.

Parameters:

tableName - the table name

constraintName - the constraint name

Method Detail

setPretty

public DropTableConstraint setPretty(boolean pretty)

Overrides:

setPretty in class SqlPart

collectSqlFragment

public void collectSqlFragment(CodeWriter writer)

Specified by:

collectSqlFragment in class SqlPart

getTableName

public String getTableName()

Returns the table name.

Returns:

the table name

setTableName

public DropTableConstraint setTableName(String tableName)

Sets the table name.

Parameters:

tableName - the table name

Returns:

this instance

getConstraintName

public String getConstraintName()

Returns the constraint name.

Returns:

the constraint name

setConstraintName

public DropTableConstraint setConstraintName(String constraintName)

Sets the constraint name.

Parameters:

constraintName - the constraint name

Returns:

this instance