com.northconcepts.datapipeline.sql.mysql

Class DropTableConstraint

java.lang.Object

com.northconcepts.datapipeline.jdbc.sql.SqlPart

com.northconcepts.datapipeline.sql.mysql.MySqlPart

com.northconcepts.datapipeline.sql.mysql.DropTableConstraint

public class DropTableConstraint
extends MySqlPart

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

Sample Generated SQL:

ALTER TABLE person DROP CONSTRAINT email_check

Constructor Summary

Constructors

Constructor and Description
DropTableConstraint()
DropTableConstraint(String tableName, String constraintName)

Method Summary

Modifier and Type	Method and Description
void	collectSqlFragment(CodeWriter writer)
String	getConstraintName()
String	getTableName()
DropTableConstraint	setConstraintName(String constraintName)
DropTableConstraint	setPretty(boolean pretty)
DropTableConstraint	setTableName(String tableName)

Methods inherited from class com.northconcepts.datapipeline.sql.mysql.MySqlPart

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)

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()

setTableName

public DropTableConstraint setTableName(String tableName)

getConstraintName

public String getConstraintName()

setConstraintName

public DropTableConstraint setConstraintName(String constraintName)