Package org.pgcodekeeper.core.schema.ms

Class MsSchema

java.lang.Object

org.pgcodekeeper.core.schema.PgStatement

org.pgcodekeeper.core.schema.AbstractSchema

org.pgcodekeeper.core.schema.ms.MsSchema

All Implemented Interfaces:

IHashable, ISchema, IStatement, IStatementContainer

public final class MsSchema
extends AbstractSchema

Represents a Microsoft SQL schema that contains database objects like tables, views, functions, and procedures. Provides SQL generation for schema creation and management.

Field Summary

Fields inherited from class org.pgcodekeeper.core.schema.PgStatement

GO

Constructor Summary

Constructors

Constructor	Description
MsSchema(String name)	Creates a new Microsoft SQL schema.

Method Summary

Modifier and Type	Method	Description
ObjectState	appendAlterSQL(PgStatement newCondition, SQLScript script)	Fill script with object changes and return change type
void	getCreationSQL(SQLScript script)	Generates the SQL statements needed to create this database object.
DatabaseType	getDbType()

Methods inherited from class org.pgcodekeeper.core.schema.AbstractSchema

addChild, addFunction, addSequence, addTable, addType, addView, compare, compareChildren, computeHash, getChild, getConstraintByName, getDatabase, getFunction, getFunctions, getIndexByName, getRelation, getRelations, getSequence, getSequences, getStatementContainer, getStatementContainers, getStatementType, getTable, getTables, getType, getView, getViews, shallowCopy

Methods inherited from class org.pgcodekeeper.core.schema.PgStatement

addAllDeps, addDep, addPrivilege, appendAlterComments, appendComments, appendOwnerSQL, canDrop, canDropBeforeCreate, checkComments, clearPrivileges, deepCopy, equals, getAuthor, getBareName, getChildren, getComment, getDeps, getDescendants, getDropSQL, getDropSQL, getLibName, getLocation, getName, getObjectState, getObjectState, getOwner, getParent, getPrivileges, getQualifiedName, getSQL, getTwin, getTypeName, hasChildren, hashCode, isLib, isOwned, isSubElement, setAuthor, setComment, setLibName, setLocation, setOwner, setParent, toString

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.pgcodekeeper.core.schema.IStatement

getBareName, getComment, getName, getParent, getQualifiedName

Constructor Details

MsSchema

public MsSchema(String name)

Creates a new Microsoft SQL schema.

Parameters:

name - the schema name

Method Details

getCreationSQL

public void getCreationSQL(SQLScript script)

Description copied from class: PgStatement

Generates the SQL statements needed to create this database object. This is an abstract method that must be implemented by subclasses to provide the specific CREATE SQL for each object type.

Specified by:

getCreationSQL in class PgStatement

Parameters:

script - the SQL script to append creation statements to

appendAlterSQL

public ObjectState appendAlterSQL(PgStatement newCondition,
 SQLScript script)

Description copied from class: PgStatement

Fill script with object changes and return change type

Specified by:

appendAlterSQL in class PgStatement

Parameters:

newCondition - new object state

script - script to collect changes

Returns:

object change type

getDbType

public DatabaseType getDbType()

Overrides:

getDbType in class PgStatement