Package wsatools :: Package DbConnect :: Module Schema :: Class Index

Class Index

source code

A database non-clustered index schema.

Instance Methods

[hide private]

str

createCommand(self)
Returns: Unique beginning of a create statement for this object in an SQL script.

source code

str

createSQL(self)
Returns: Full SQL line to create the object.

source code

str

dropSQL(self)
Returns: Full SQL line to drop the object.

source code

Inherited from _Schema: __cmp__, __str__, parseName

Inherited from object: __delattr__, __format__, __getattribute__, __hash__, __init__, __new__, __reduce__, __reduce_ex__, __repr__, __setattr__, __sizeof__, __subclasshook__

Class Variables

[hide private]

identifier = 'INDEX'
SQL identifier for this type of database object.

attrList = ''
Comma-separated list of attribute names that make up this index.

fileGroup = 'Indices_FG'
File group where index is created.

fillFactor = None
Optional page fill factor - an integer percentage.

tableName = ''
Name of the database table that the index applies to.

Inherited from _Schema: name, releasable, schemaFileName

Properties

[hide private]

Inherited from object: __class__

Method Details

[hide private]

createCommand(self)

source code

Returns: str: Unique beginning of a create statement for this object in an SQL script.
Overrides: _Schema.createCommand

createSQL(self)

source code

Returns: str: Full SQL line to create the object.
Overrides: _Schema.createSQL

dropSQL(self)

source code

Returns: str: Full SQL line to drop the object.
Overrides: _Schema.dropSQL