📄 sqldmo_tlb.pas
字号:
SQLDMOObj_TargetServer = $00207000;
SQLDMOObj_TargetServerGroup = $00208000;
SQLDMOObj_Category = $00209000;
SQLDMOObj_Schedule = $00210000;
SQLDMOObj_JobFilter = $00211000;
SQLDMOObj_JobHistoryFilter = $00212000;
SQLDMOObj_JobSchedule = $00213000;
SQLDMOObj_Last = $10000000;
// SQLDMO_KEY_TYPE constants
type
SQLDMO_KEY_TYPE = TOleEnum;
const
SQLDMOKey_Unknown = $00000000;
SQLDMOKey_Primary = $00000001;
SQLDMOKey_Unique = $00000002;
SQLDMOKey_Foreign = $00000003;
// SQLDMO_DEVICE_TYPE constants
type
SQLDMO_DEVICE_TYPE = TOleEnum;
const
SQLDMODevice_Unknown = $00000064;
SQLDMODevice_DiskDump = $00000002;
SQLDMODevice_FloppyADump = $00000003;
SQLDMODevice_FloppyBDump = $00000004;
SQLDMODevice_TapeDump = $00000005;
SQLDMODevice_PipeDump = $00000006;
SQLDMODevice_CDROM = $00000007;
// SQLDMO_PRIVILEGE_TYPE constants
type
SQLDMO_PRIVILEGE_TYPE = TOleEnum;
const
SQLDMOPriv_Unknown = $00000000;
SQLDMOPriv_Select = $00000001;
SQLDMOPriv_Insert = $00000002;
SQLDMOPriv_Update = $00000004;
SQLDMOPriv_Delete = $00000008;
SQLDMOPriv_Execute = $00000010;
SQLDMOPriv_References = $00000020;
SQLDMOPriv_AllObjectPrivs = $0000003F;
SQLDMOPriv_CreateTable = $00000080;
SQLDMOPriv_CreateDatabase = $00000100;
SQLDMOPriv_CreateView = $00000200;
SQLDMOPriv_CreateProcedure = $00000400;
SQLDMOPriv_DumpDatabase = $00000800;
SQLDMOPriv_CreateDefault = $00001000;
SQLDMOPriv_DumpTransaction = $00002000;
SQLDMOPriv_CreateRule = $00004000;
SQLDMOPriv_DumpTable = $00008000;
SQLDMOPriv_AllDatabasePrivs = $0000FF80;
// SQLDMO_PROCEDURE_TYPE constants
type
SQLDMO_PROCEDURE_TYPE = TOleEnum;
const
SQLDMOProc_Unknown = $00000000;
SQLDMOProc_Standard = $00000001;
SQLDMOProc_Extended = $00000002;
SQLDMOProc_Macro = $00000003;
SQLDMOProc_ReplicationFilter = $00000004;
// SQLDMO_TRIGGER_TYPE constants
type
SQLDMO_TRIGGER_TYPE = TOleEnum;
const
SQLDMOTrig_Unknown = $00000000;
SQLDMOTrig_Insert = $00000001;
SQLDMOTrig_Update = $00000002;
SQLDMOTrig_Delete = $00000004;
SQLDMOTrig_All = $00000007;
// SQLDMO_INDEX_TYPE constants
type
SQLDMO_INDEX_TYPE = TOleEnum;
const
SQLDMOIndex_Default = $00000000;
SQLDMOIndex_IgnoreDupKey = $00000001;
SQLDMOIndex_Unique = $00000002;
SQLDMOIndex_Clustered = $00000010;
SQLDMOIndex_PadIndex = $00000100;
SQLDMOIndex_SortedData = $00000200;
SQLDMOIndex_SortedDataReorg = $00002000;
SQLDMOIndex_DropExist = $00008000;
SQLDMOIndex_Valid = $0000A313;
SQLDMOIndex_Hypothetical = $00000020;
SQLDMOIndex_DRIPrimaryKey = $00000800;
SQLDMOIndex_DRIUniqueKey = $00001000;
SQLDMOIndex_DRIIndex = $00001800;
// SQLDMO_QUERY_DATATYPE constants
type
SQLDMO_QUERY_DATATYPE = TOleEnum;
const
SQLDMO_DTypeUnknown = $00000000;
SQLDMO_DTypeChar = $00000001;
SQLDMO_DTypeText = $FFFFFFFF;
SQLDMO_DTypeVarchar = $0000000C;
SQLDMO_DTypeVarBinary = $FFFFFFFD;
SQLDMO_DTypeBinary = $FFFFFFFE;
SQLDMO_DTypeImage = $FFFFFFFC;
SQLDMO_DTypeFloat4 = $00000007;
SQLDMO_DTypeFloat8 = $00000008;
SQLDMO_DTypeInt1 = $FFFFFFFA;
SQLDMO_DTypeInt2 = $00000005;
SQLDMO_DTypeInt4 = $00000004;
SQLDMO_DTypeMoney4 = $00000003;
SQLDMO_DTypeMoney = $00000003;
SQLDMO_DTypeDateTime = $FFFFFFFE;
SQLDMO_DTypeDateTime4 = $0000005D;
SQLDMO_DTypeBit = $FFFFFFF9;
SQLDMO_DTypeUChar = $FFFFFFF8;
SQLDMO_DTypeUVarchar = $FFFFFFF7;
SQLDMO_DTypeGUID = $FFFFFFF5;
SQLDMO_DTypeNText = $FFFFFFF6;
// SQLDMO_AUDIT_TYPE constants
type
SQLDMO_AUDIT_TYPE = TOleEnum;
const
SQLDMOAudit_None = $00000000;
SQLDMOAudit_Success = $00000001;
SQLDMOAudit_Failure = $00000002;
SQLDMOAudit_All = $00000003;
// SQLDMO_SECURITY_TYPE constants
type
SQLDMO_SECURITY_TYPE = TOleEnum;
const
SQLDMOSecurity_Min = $00000000;
SQLDMOSecurity_Normal = $00000000;
SQLDMOSecurity_Integrated = $00000001;
SQLDMOSecurity_Mixed = $00000002;
SQLDMOSecurity_Max = $00000002;
// SQLDMO_MEDIA_TYPE constants
type
SQLDMO_MEDIA_TYPE = TOleEnum;
const
SQLDMOMedia_Floppy = $00000001;
SQLDMOMedia_FixedDisk = $00000002;
SQLDMOMedia_Tape = $00000004;
SQLDMOMedia_CDROM = $00000008;
SQLDMOMedia_All = $0000000F;
// SQLDMO_PERFMON_TYPE constants
type
SQLDMO_PERFMON_TYPE = TOleEnum;
const
SQLDMOPerfmon_None = $000003E8;
SQLDMOPerfmon_MinSet = $00000000;
SQLDMOPerfmon_Continuous = $00000000;
SQLDMOPerfmon_OnDemand = $00000001;
SQLDMOPerfmon_MaxSet = $00000001;
// SQLDMO_DBSTATUS_TYPE constants
type
SQLDMO_DBSTATUS_TYPE = TOleEnum;
const
SQLDMODBStat_Normal = $00000000;
SQLDMODBStat_Loading = $00000020;
SQLDMODBStat_Recovering = $000000C0;
SQLDMODBStat_Suspect = $00000100;
SQLDMODBStat_Offline = $00000200;
SQLDMODBStat_Inaccessible = $000003E0;
SQLDMODBStat_EmergencyMode = $00008000;
SQLDMODBStat_All = $000083E0;
// SQLDMO_COPYDATA_TYPE constants
type
SQLDMO_COPYDATA_TYPE = TOleEnum;
const
SQLDMOCopyData_False = $00000000;
SQLDMOCopyData_Replace = $00000001;
SQLDMOCopyData_Append = $00000002;
// SQLDMO_DATAFILE_TYPE constants
type
SQLDMO_DATAFILE_TYPE = TOleEnum;
const
SQLDMODataFile_CommaDelimitedChar = $00000001;
SQLDMODataFile_Default = $00000001;
SQLDMODataFile_TabDelimitedChar = $00000002;
SQLDMODataFile_SpecialDelimitedChar = $00000003;
SQLDMODataFile_NativeFormat = $00000004;
SQLDMODataFile_UseFormatFile = $00000005;
// SQLDMO_STATUSINFO_TYPE constants
type
SQLDMO_STATUSINFO_TYPE = TOleEnum;
const
SQLDMOStatInfo_Unknown = $00000000;
SQLDMOStatInfo_DatabaseStatus = $00000001;
SQLDMOStatInfo_DatabaseSpace = $00000002;
SQLDMOStatInfo_AutoVerifyConnection = $00000004;
SQLDMOStatInfo_All = $00000007;
// SQLDMO_SCRIPT_TYPE constants
type
SQLDMO_SCRIPT_TYPE = TOleEnum;
const
SQLDMOScript_Default = $00000004;
SQLDMOScript_Drops = $00000001;
SQLDMOScript_ObjectPermissions = $00000002;
SQLDMOScript_PrimaryObject = $00000004;
SQLDMOScript_ClusteredIndexes = $00000008;
SQLDMOScript_Triggers = $00000010;
SQLDMOScript_DatabasePermissions = $00000020;
SQLDMOScript_Permissions = $00000022;
SQLDMOScript_ToFileOnly = $00000040;
SQLDMOScript_Bindings = $00000080;
SQLDMOScript_AppendToFile = $00000100;
SQLDMOScript_NoDRI = $00000200;
SQLDMOScript_UDDTsToBaseType = $00000400;
SQLDMOScript_IncludeIfNotExists = $00001000;
SQLDMOScript_NonClusteredIndexes = $00002000;
SQLDMOScript_Indexes = $00012008;
SQLDMOScript_Aliases = $00004000;
SQLDMOScript_NoCommandTerm = $00008000;
SQLDMOScript_DRIIndexes = $00010000;
SQLDMOScript_IncludeHeaders = $00020000;
SQLDMOScript_OwnerQualify = $00040000;
SQLDMOScript_TimestampToBinary = $00080000;
SQLDMOScript_SortedData = $00100000;
SQLDMOScript_SortedDataReorg = $00200000;
SQLDMOScript_TransferDefault = $000670FF;
SQLDMOScript_DRI_NonClustered = $00400000;
SQLDMOScript_DRI_Clustered = $00800000;
SQLDMOScript_DRI_Checks = $01000000;
SQLDMOScript_DRI_Defaults = $02000000;
SQLDMOScript_DRI_UniqueKeys = $04000000;
SQLDMOScript_DRI_ForeignKeys = $08000000;
SQLDMOScript_DRI_PrimaryKey = $10000000;
SQLDMOScript_DRI_AllKeys = $1C000000;
SQLDMOScript_DRI_AllConstraints = $1F000000;
SQLDMOScript_DRI_All = $1FC00000;
SQLDMOScript_DRIWithNoCheck = $20000000;
SQLDMOScript_NoIdentity = $40000000;
SQLDMOScript_UseQuotedIdentifiers = $80000000;
// SQLDMO_SCRIPT2_TYPE constants
type
SQLDMO_SCRIPT2_TYPE = TOleEnum;
const
SQLDMOScript2_Default = $00000000;
SQLDMOScript2_AnsiPadding = $00000001;
SQLDMOScript2_AnsiFile = $00000002;
SQLDMOScript2_UnicodeFile = $00000004;
SQLDMOScript2_NonStop = $00000008;
SQLDMOScript2_NoFG = $00000010;
SQLDMOScript2_MarkTriggers = $00000020;
SQLDMOScript2_OnlyUserTriggers = $00000040;
SQLDMOScript2_EncryptPWD = $00000080;
SQLDMOScript2_SeparateXPs = $00000100;
// SQLDMO_XFRSCRIPTMODE_TYPE constants
type
SQLDMO_XFRSCRIPTMODE_TYPE = TOleEnum;
const
SQLDMOXfrFile_Default = $00000001;
SQLDMOXfrFile_SummaryFiles = $00000001;
SQLDMOXfrFile_SingleFile = $00000002;
SQLDMOXfrFile_SingleFilePerObject = $00000004;
// SQLDMO_DEPENDENCY_TYPE constants
type
SQLDMO_DEPENDENCY_TYPE = TOleEnum;
const
SQLDMODep_Parents = $00000000;
SQLDMODep_FullHierarchy = $00010000;
SQLDMODep_OrderDescending = $00020000;
SQLDMODep_Children = $00040000;
SQLDMODep_ReturnInputObject = $00080000;
SQLDMODep_FirstLevelOnly = $00100000;
SQLDMODep_DRIOnly = $00200000;
SQLDMODep_Valid = $003F0000;
// SQLDMO_OBJSORT_TYPE constants
type
SQLDMO_OBJSORT_TYPE = TOleEnum;
const
SQLDMOObjSort_Name = $00000000;
SQLDMOObjSort_Type = $00000001;
SQLDMOObjSort_Owner = $00000002;
SQLDMOObjSort_Date = $00000003;
// SQLDMO_SVCSTATUS_TYPE constants
type
SQLDMO_SVCSTATUS_TYPE = TOleEnum;
const
SQLDMOSvc_Unknown = $00000000;
SQLDMOSvc_Running = $00000001;
SQLDMOSvc_Paused = $00000002;
SQLDMOSvc_Stopped = $00000003;
SQLDMOSvc_Starting = $00000004;
SQLDMOSvc_Stopping = $00000005;
SQLDMOSvc_Continuing = $00000006;
SQLDMOSvc_Pausing = $00000007;
// SQLDMO_SRVOPTION_TYPE constants
type
SQLDMO_SRVOPTION_TYPE = TOleEnum;
const
SQLDMOSrvOpt_Unknown = $00000000;
SQLDMOSrvOpt_RPC = $00000001;
SQLDMOSrvOpt_Publisher = $00000002;
SQLDMOSrvOpt_Subscriber = $00000004;
SQLDMOSrvOpt_Distributor = $00000008;
SQLDMOSrvOpt_DistPublisher = $00000010;
SQLDMOSrvOpt_RPC_out = $00000040;
SQLDMOSrvOpt_DataAccess = $00000080;
SQLDMOSrvOpt_CollationCompatible = $00000100;
SQLDMOSrvOpt_NonTransacted = $00000200;
SQLDMOSrvOpt_InProcess = $00000400;
SQLDMOSrvOpt_IndexAsAccessPath = $00000800;
SQLDMOSrvOpt_LevelZeroOnly = $00001000;
SQLDMOSrvOpt_NestedQueries = $00002000;
SQLDMOSrvOpt_DynamicParameters = $00004000;
// SQLDMO_TABLEATT_TYPE constants
type
SQLDMO_TABLEATT_TYPE = TOleEnum;
const
SQLDMOTabAtt_Identity = $00000001;
SQLDMOTabAtt_SystemObject = $00000002;
SQLDMOTabAtt_ForeignKey = $00000004;
SQLDMOTabAtt_Referenced = $00000008;
SQLDMOTabAtt_Published = $00000020;
SQLDMOTabAtt_Replicated = $00000040;
SQLDMOTabAtt_Check = $00000080;
SQLDMOTabAtt_Replica = $00000100;
SQLDMOTabAtt_PrimaryKey = $00000200;
SQLDMOTabAtt_Unique = $00000400;
SQLDMOTabAtt_Default = $00000800;
SQLDMOTabAtt_ReplCheck = $00001000;
SQLDMOTabAtt_HasConstraint = $00001C84;
// SQLDMO_INTSECLOGIN_TYPE constants
type
SQLDMO_INTSECLOGIN_TYPE = TOleEnum;
const
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -