DropTableConstraint (Data Pipeline JavaDoc)

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

Description

DropTableConstraint()

DropTableConstraint(String tableName, String constraintName)
Method Summary

Modifier and Type

Method

Description

void

collectSqlFragment(CodeWriter writer)

Writes this part's SQL to the writer; used by SqlPart.getSqlFragment() and by enclosing parts.

String

getConstraintName()

String

getTableName()

DropTableConstraint

setConstraintName(String constraintName)

DropTableConstraint

setPretty(boolean pretty)

Indicates if SqlPart.getSqlFragment() adds line breaks and indentation instead of using one line (default is false).

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 Details
- DropTableConstraint
  
  public DropTableConstraint()
- DropTableConstraint
  
  public DropTableConstraint(String tableName, String constraintName)
Method Details
- setPretty
  
  public DropTableConstraint setPretty(boolean pretty)
  
  Description copied from class: SqlPart
  
  Indicates if SqlPart.getSqlFragment() adds line breaks and indentation instead of using one line (default is false).
  
  Overrides:
  
  setPretty in class SqlPart
- collectSqlFragment
  
  public void collectSqlFragment(CodeWriter writer)
  
  Description copied from class: SqlPart
  
  Writes this part's SQL to the writer; used by SqlPart.getSqlFragment() and by enclosing parts.
  
  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)