TEDBSQLStatementType

Unit: edbcomps

TEDBSQLStatementType = (stUnknown,stSelect,stInsert,stUpdate,
      stDelete, stCreateDatabase,stCreateUser,stCreateRole,stCreateJob,
       stCreateStore,stCreateModule,stCreateTextFilter,
      stCreateWordGenerator,stCreateMigrator, stCreateTable,
      stCreateView,stCreateIndex, stCreateTrigger,stCreateTextIndex,
      stCreateFunction, stCreateProcedure, stDropDatabase,stDropUser,
      stDropRole, stDropJob,stDropStore,stDropModule,stDropTextFilter,
      stDropWordGenerator,stDropMigrator, stDropTable,stDropView,
      stDropIndex, stDropTrigger,stDropFunction,stDropProcedure,
      stAlterDatabase,stAlterUser,stAlterRole,stAlterJob, stAlterStore,
      stAlterModule,stAlterTextFilter, stAlterWordGenerator,
      stAlterMigrator, stAlterTable,stAlterView,stAlterIndex,
      stAlterTrigger,stAlterFunction,stAlterProcedure,
      stRenameDatabase,stRenameUser,stRenameRole, stRenameJob,
      stRenameStore,stRenameModule,stRenameTextFilter,
      stRenameWordGenerator,stRenameMigrator,stRenameTable,
      stRenameView,stRenameIndex,stRenameTrigger, stRenameFunction,
      stRenameProcedure, stGrant,stRevoke, stRepairTable,stVerifyTable,
      stOptimizeTable,stEmptyTable, stExportTable,stImportTable,
      stSetBackupsStore,stBackupDatabase,stRestoreDatabase,
      stSetUpdatesStore, stSaveDatabaseUpdates,stLoadDatabaseUpdates,
      stPublishDatabase,stUnpublishDatabase, stSetMigrator,
      stMigrateDatabase, stDisconnectServerSession,
      stRemoveServerSession, stSetFilesStore,stCopyFile,stRenameFile,
      stDeleteFile, stSetInformationCollate,stCompareDatabase,
      stEnableJob,stEnableJobs,stEnableTrigger,stEnableTiggers,
      stEnableDefaults,stEnableGenerated,stEnableStatementLogging,
      stDisableJob,stDisableJobs,stDisableTrigger,stDisableTriggers,
      stDisableDefaults,stDisableGenerated,stDisableStatementLogging,
      stSetStatementCache,stSetProcedureCache)

This type is used to indicate the type of SQL statement in the TEDBQuery SQL property.

Element

Description

stAlterDatabase	Indicates an ALTER DATABASE statement.
stAlterFunction	Indicates an ALTER FUNCTION statement.
stAlterIndex	Indicates an ALTER INDEX statement.
stAlterJob	Indicates an ALTER JOB statement.
stAlterMigrator	Indicates an ALTER MIGRATOR statement.
stAlterModule	Indicates an ALTER MODULE statement.
stAlterProcedure	Indicates an ALTER PROCEDURE statement.
stAlterRole	Indicates an ALTER ROLE statement.
stAlterStore	Indicates an ALTER STORE statement.
stAlterTable	Indicates an ALTER TABLE statement.
stAlterTextFilter	Indicates an ALTER TEXT FILTER statement.
stAlterTrigger	Indicates an ALTER TRIGGER statement.
stAlterUser	Indicates an ALTER USER statement.
stAlterView	Indicates an ALTER VIEW statement.
stAlterWordGenerator	Indicates an ALTER WORD GENERATOR statement.
stBackupDatabase	Indicates a BACKUP DATABASE statement.
stCompareDatabase	Indicates a COMPARE DATABASE statement.
stCopyFile	Indicates a COPY FILE statement.
stCreateDatabase	Indicates a CREATE DATABASE statement.
stCreateFunction	Indicates a CREATE FUNCTION statement.
stCreateIndex	Indicates a CREATE INDEX statement.
stCreateJob	Indicates a CREATE JOB statement.
stCreateMigrator	Indicates a CREATE MIGRATOR statement.
stCreateModule	Indicates a CREATE MODULE statement.
stCreateProcedure	Indicates a CREATE PROCEDURE statement.
stCreateRole	Indicates a CREATE ROLE statement.
stCreateStore	Indicates a CREATE STORE statement.
stCreateTable	Indicates a CREATE TABLE statement.
stCreateTextFilter	Indicates a CREATE TEXT FILTER statement.
stCreateTextIndex	Indicates a CREATE TEXT INDEX statement.
stCreateTrigger	Indicates a CREATE TRIGGER statement.
stCreateUser	Indicates a CREATE USER statement.
stCreateView	Indicates a CREATE VIEW statement.
stCreateWordGenerator	Indicates a CREATE WORD GENERATOR statement.
stDelete	Indicates a DELETE statement.
stDeleteFile	Indicates a RENAME FILE statement.
stDisableDefaults
stDisableGenerated
stDisableJob
stDisableJobs
stDisableStatementLogging
stDisableTrigger
stDisableTriggers
stDisconnectServerSession	Indicates a DISCONNECT SERVER SESSION statement.
stDropDatabase	Indicates a DROP DATABASE statement.
stDropFunction	Indicates a DROP FUNCTION statement.
stDropIndex	Indicates a DROP INDEX statement.
stDropJob	Indicates a DROP JOB statement.
stDropMigrator	Indicates a DROP MIGRATOR statement.
stDropModule	Indicates a DROP MODULE statement.
stDropProcedure	Indicates a DROP PROCEDURE statement.
stDropRole	Indicates a DROP ROLE statement.
stDropStore	Indicates a DROP STORE statement.
stDropTable	Indicates a DROP TABLE statement.
stDropTextFilter	Indicates a DROP TEXT FILTER statement.
stDropTrigger	Indicates a DROP TRIGGER statement.
stDropUser	Indicates a DROP USER statement.
stDropView	Indicates a DROP VIEW statement.
stDropWordGenerator	Indicates a DROP WORD GENERATOR statement.
stEmptyTable	Indicates an EMPTY TABLE statement.
stEnableDefaults
stEnableGenerated
stEnableJob
stEnableJobs
stEnableStatementLogging
stEnableTiggers
stEnableTrigger
stExportTable	Indicates an EXPORT TABLE statement.
stGrant	Indicates a GRANT statement.
stImportTable	Indicates an IMPORT TABLE statement.
stInsert	Indicates an INSERT statement.
stLoadDatabaseUpdates	Indicates a LOAD UPDATES statement.
stMigrateDatabase	Indicates a MIGRATE DATABASE statement.
stOptimizeTable	Indicates an OPTIMIZE TABLE statement.
stPublishDatabase	Indicates a PUBLISH DATABASE statement.
stRemoveServerSession	Indicates a REMOVE SERVER SESSION statement.
stRenameDatabase	Indicates an RENAME DATABASE statement.
stRenameFile	Indicates a RENAME FILE statement.
stRenameFunction	Indicates an RENAME FUNCTION statement.
stRenameIndex	Indicates an RENAME INDEX statement.
stRenameJob	Indicates an RENAME JOB statement.
stRenameMigrator	Indicates an RENAME MIGRATOR statement.
stRenameModule	Indicates a RENAME MODULE statement.
stRenameProcedure	Indicates an RENAME PROCEDURE statement.
stRenameRole	Indicates an RENAME ROLE statement.
stRenameStore	Indicates an RENAME STORE statement.
stRenameTable	Indicates an RENAME TABLE statement.
stRenameTextFilter	Indicates an RENAME TEXT FILTER statement.
stRenameTrigger	Indicates an RENAME TRIGGER statement.
stRenameUser	Indicates an RENAME USER statement.
stRenameView	Indicates an RENAME VIEW statement.
stRenameWordGenerator	Indicates an RENAME WORD GENERATOR statement.
stRepairTable	Indicates a REPAIR TABLE statement.
stRestoreDatabase	Indicates a RESTORE DATABASE statement.
stRevoke	Indicates a REVOKE statement.
stSaveDatabaseUpdates	Indicates a SAVE UPDATES statement.
stSelect	Indicates a SELECT statement.
stSetBackupsStore	Indicates a SET BACKUPS STORE statement.
stSetFilesStore	Indicates a SET FILES STORE statement.
stSetInformationCollate	Indicates a SET INFORMATION COLLATE statement.
stSetMigrator
stSetProcedureCache
stSetStatementCache
stSetUpdatesStore	Indicates a SET UPDATES STORE statement.
stUnknown	Indicates an unknown statement.
stUnpublishDatabase	Indicates an UNPUBLISH DATABASE statement.
stUpdate	Indicates an UPDATE statement.
stVerifyTable	Indicates a VERIFY TABLE statement.

More Support Options

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Incident Reports

Roadmap