📄 sqldmo.h
字号:
SQLDMOObj_Last = 0x10000000 // End of enumeration.
} SQLDMO_OBJECT_TYPE;
// ***************************************************************************
// Copyright (C) 1985-1999 Microsoft Corporation.
// @File: core_itf.h
//
// Purpose: CORE defines and interfaces
//
//
// Notes:
//
// History:
//
// @Version: Shiloh
// 65649 IXL 07/08/00 remove job server from job script
// 61175 WG 05/10/00 VIA Netlibs
// 60740 WG 05/08/00 New dboptions for recovery
// 60549 WG 05/01/00 New ServerRole bulkadmin
// 60311 WG 04/27/00 Encrypted UDF checking
// 55928 WG 02/28/00 Compatibility level
// 54473 WG 02/11/00 New script option
// 54427 WG 02/11/00 Restore BackupSetName
// 54311 WG 02/10/00 Extended Property
// 53618 WG 02/03/00 UDF ListPermission
// 53312 WG 01/31/00 Transferrable encryption
// 53089 WG 01/28/00 New Backup Restore option
// 52952 WG 01/27/00 Linked Server option
// 52788 WG 01/26/00 Linked Server options
// 52521 WG 01/24/00 Backup and Restore
// 52513 WG 01/24/00 GrantedGranted
// 52356 WG 01/21/00 ProductLevel
// 51928 WG 01/18/00 EnumAvailableMedia
// 51899 WG 01/18/00 DatabaseRole
// 51623 WG 01/17/00 IsDeleted
// 51534 WG 01/13/00 CheckSyntax
// 50625 WG 01/04/00 Syntax check for default and rule
// 50559 WG 01/03/00 Language ID on fulltext column
// 50447 WG 12/29/99 EnumDependencies with system objects
// 49768 WG 12/14/99 Support bigint in QueryResult
// 49712 WG 12/13/99 Refresh for LinkedServer
// 49522 WG 12/10/99 Script Job with enable flag
// 49452 WG 12/10/99 EnumParameters for UDF
// 49129 WG 12/07/99 CTS tracking
//
//
// @EndHeader@
// ***************************************************************************
typedef SQLDMO_HELPID(SQLDMO_KEY_TYPE) enum {
SQLDMOKey_Unknown = 0,
SQLDMOKey_Primary = 1,
SQLDMOKey_Unique = 2,
SQLDMOKey_Foreign = 3
} SQLDMO_KEY_TYPE;
typedef SQLDMO_HELPID(SQLDMO_DEVICE_TYPE) enum {
SQLDMODevice_Unknown = 100,
SQLDMODevice_DiskDump = 2,
SQLDMODevice_FloppyADump = 3,
SQLDMODevice_FloppyBDump = 4,
SQLDMODevice_TapeDump = 5,
SQLDMODevice_PipeDump = 6,
SQLDMODevice_CDROM = 7
} SQLDMO_DEVICE_TYPE;
typedef SQLDMO_HELPID(SQLDMO_PRIVILEGE_TYPE) enum {
SQLDMOPriv_Unknown = 0,
// Privilege values, different from sysprotects as we need to bitmask.
// Object privileges.
SQLDMOPriv_Select = 1,
SQLDMOPriv_Insert = 2,
SQLDMOPriv_Update = 4,
SQLDMOPriv_Delete = 8,
SQLDMOPriv_Execute = 16,
SQLDMOPriv_References = 32,
SQLDMOPriv_AllObjectPrivs = 63,
// Database (statement) privileges.
SQLDMOPriv_CreateTable = 128,
SQLDMOPriv_CreateDatabase = 256,
SQLDMOPriv_CreateView = 512,
SQLDMOPriv_CreateProcedure = 1024,
SQLDMOPriv_DumpDatabase = 2048,
SQLDMOPriv_CreateDefault = 4096,
SQLDMOPriv_DumpTransaction = 8192,
SQLDMOPriv_CreateRule = 16384,
SQLDMOPriv_DumpTable = 32768,
SQLDMOPriv_CreateFunction = 65536,
SQLDMOPriv_AllDatabasePrivs = 130944
} SQLDMO_PRIVILEGE_TYPE;
typedef SQLDMO_HELPID(SQLDMO_PROCEDURE_TYPE) enum {
SQLDMOProc_Unknown = 0,
SQLDMOProc_Standard = 1,
SQLDMOProc_Extended = 2,
SQLDMOProc_Macro = 3,
SQLDMOProc_ReplicationFilter = 4
} SQLDMO_PROCEDURE_TYPE;
// Trigger types may be OR'd together.
typedef SQLDMO_HELPID(SQLDMO_TRIGGER_TYPE) enum {
SQLDMOTrig_Unknown = 0,
SQLDMOTrig_Insert = 1,
SQLDMOTrig_Update = 2,
SQLDMOTrig_Delete = 4,
SQLDMOTrig_All = 7
} SQLDMO_TRIGGER_TYPE;
typedef SQLDMO_HELPID(SQLDMO_INDEX_TYPE) enum { // SQLDMO Internal: sync with ntinc\index.h
// Index type values as in sysindexes.status.
SQLDMOIndex_Default = 0x0000,
SQLDMOIndex_IgnoreDupKey = 0x0001,
SQLDMOIndex_Unique = 0x0002,
// SQLDMOIndex_IgnoreDupRow = 0x0004, // obsolete in 7.0
SQLDMOIndex_Clustered = 0x0010,
// SQLDMOIndex_AllowDupRow = 0x0040, // obsolete in 7.0
SQLDMOIndex_PadIndex = 0x0100, // new for 7.0, fillfactor applies to index nodes also
SQLDMOIndex_SortedData = 0x0200,
SQLDMOIndex_SortedDataReorg = 0x2000, // 6.0-only; sorted-data with reorganization
SQLDMOIndex_DropExist = 0x8000, // new for 7.0, Drop the existing index
// SQLDMOIndex_Valid = 0xA357, // Any of foregoing (writable) types
SQLDMOIndex_Valid = 0xA313, // Any of foregoing (writable) types
SQLDMOIndex_Hypothetical = 0x0020, // new for 7.0, statistics only index, we get this for both 'CREATE STATISTICS' and 'CREATE INDEX...WITH STATISTICS_ONLY'
SQLDMOIndex_DRIPrimaryKey = 0x0800, // 6.0-only, readonly; DRI-generated types
SQLDMOIndex_DRIUniqueKey = 0x1000,
SQLDMOIndex_DRIIndex = 0x1800, // Index implements DRI (DRIPrimaryKey | DRIUniqueKey)
SQLDMOIndex_NoRecompute = 0x01000000, // new for 7.0
} SQLDMO_INDEX_TYPE;
typedef SQLDMO_HELPID(SQLDMO_QUERY_DATATYPE) enum {
// Indexed as per ..\common\inc\sql.hpp and sql.h sqlext.h datatype constants.
SQLDMO_DTypeUnknown = 0,
SQLDMO_DTypeChar = 1, // SQL_CHAR
SQLDMO_DTypeText = -1, // SQL_LONGVARCHAR
SQLDMO_DTypeVarchar = 12, // SQL_VARCHAR
SQLDMO_DTypeVarBinary = -3, // SQL_VARBINARY
SQLDMO_DTypeBinary = -2, // SQL_BINARY
SQLDMO_DTypeImage = -4, // SQL_LONGVARBINARY
SQLDMO_DTypeFloat4 = 7, // SQL_REAL
SQLDMO_DTypeFloat8 = 8, // SQL_DOUBLE
SQLDMO_DTypeInt1 = -6, // SQL_TINYINT
SQLDMO_DTypeInt2 = 5, // SQL_SMALLINT
SQLDMO_DTypeInt4 = 4, // SQL_INTEGER
SQLDMO_DTypeMoney4 = 3, // SQL_DECIMAL
SQLDMO_DTypeMoney = 3, // SQL_DECIMAL
SQLDMO_DTypeDateTime = -2, // SQL_BINARY
SQLDMO_DTypeDateTime4 = 93, // SQL_TYPE_TIMESTAMP
SQLDMO_DTypeBit = -7, // SQL_BIT
SQLDMO_DTypeUChar = -8, // SQL_WCHAR
SQLDMO_DTypeUVarchar = -9, // SQL_WVARCHAR
SQLDMO_DTypeGUID = -11, // SQL_GUID
SQLDMO_DTypeNText = -10, // SQL_WLONGVARCHAR
SQLDMO_DTypeBigint = -5, // SQL_BIGINT
SQLDMO_DTypeSQLVariant = -150, // SQL_VARIANT
} SQLDMO_QUERY_DATATYPE;
typedef SQLDMO_HELPID(SQLDMO_AUDIT_TYPE) enum {
SQLDMOAudit_None = 0,
SQLDMOAudit_Success = 1,
SQLDMOAudit_Failure = 2,
SQLDMOAudit_All = 3
} SQLDMO_AUDIT_TYPE;
typedef SQLDMO_HELPID(SQLDMO_SECURITY_TYPE) enum {
SQLDMOSecurity_Min = 0,
SQLDMOSecurity_Normal = 0,
SQLDMOSecurity_Integrated = 1,
SQLDMOSecurity_Mixed = 2,
SQLDMOSecurity_Max = 2,
SQLDMOSecurity_Unknown = 9
} SQLDMO_SECURITY_TYPE;
typedef SQLDMO_HELPID(SQLDMO_MEDIA_TYPE) enum {
SQLDMOMedia_Floppy = 1,
SQLDMOMedia_FixedDisk = 2,
SQLDMOMedia_Tape = 4,
SQLDMOMedia_CDROM = 8,
SQLDMOMedia_All = 15,
SQLDMOMedia_SharedFixedDisk = 16
} SQLDMO_MEDIA_TYPE;
typedef SQLDMO_HELPID(SQLDMO_PERFMON_TYPE) enum {
SQLDMOPerfmon_None = 1000, // No perfmon integration
SQLDMOPerfmon_MinSet = 0,
SQLDMOPerfmon_Continuous = 0,
SQLDMOPerfmon_OnDemand = 1,
SQLDMOPerfmon_MaxSet = 1
} SQLDMO_PERFMON_TYPE;
typedef SQLDMO_HELPID(SQLDMO_DBSTATUS_TYPE) enum {
SQLDMODBStat_Normal = 0x0000,
SQLDMODBStat_Loading = 0x0020, // isinload
SQLDMODBStat_Recovering = 0x00c0, // 0x40 | 0x080, isinrecovery, isnotrecovered
SQLDMODBStat_Suspect = 0x0100, // issuspect, isshutdown (IsSuspect for recovery failure, IsShutdown for missing files)
SQLDMODBStat_Offline = 0x0200, // isoffline, isdetached
SQLDMODBStat_Inaccessible = 0x03e0, // Loading | Recovering | Suspect | Offline
SQLDMODBStat_EmergencyMode = 0x8000, // isemergencymode
SQLDMODBStat_Standby = 0x0400, // online as readonly, with restore log allowed
SQLDMODBStat_All = 0x87e0
} SQLDMO_DBSTATUS_TYPE;
typedef SQLDMO_HELPID(SQLDMO_COPYDATA_TYPE) enum {
SQLDMOCopyData_False = 0,
SQLDMOCopyData_Replace = 1,
SQLDMOCopyData_Append = 2
} SQLDMO_COPYDATA_TYPE;
typedef SQLDMO_HELPID(SQLDMO_DATAFILE_TYPE) enum {
// Bulk-copy datafile options (Table/View.Export and Table.Import). These are mutually exclusive.
SQLDMODataFile_CommaDelimitedChar = 0x00000001, // ColumnDelimiter == Comma, RowDelimiter == <CRLF>
SQLDMODataFile_Default = 0x00000001, // Default == csv
SQLDMODataFile_TabDelimitedChar = 0x00000002, // ColumnDelimiter == <TAB>, RowDelimiter == <CRLF>
SQLDMODataFile_SpecialDelimitedChar = 0x00000003, // Set BulkCopy.ColumnDelimiter and .RowDelimiter
SQLDMODataFile_NativeFormat = 0x00000004, // Use native datatype formats
SQLDMODataFile_UseFormatFile = 0x00000005, // Use an existing format file.
} SQLDMO_DATAFILE_TYPE;
typedef SQLDMO_HELPID(SQLDMO_STATUSINFO_TYPE) enum {
SQLDMOStatInfo_Unknown = 0, // Initialization value, not valid as a parameter
SQLDMOStatInfo_DatabaseStatus = 0x0001, // Database.Status
SQLDMOStatInfo_DatabaseSpace = 0x0002, // Database.SpaceAvailable
SQLDMOStatInfo_AutoVerifyConnection = 0x0004, // Server.VerifyConnection done automatically.
SQLDMOStatInfo_All = 0x0007 // All the foregoing
} SQLDMO_STATUSINFO_TYPE;
typedef SQLDMO_HELPID(SQLDMO_SCRIPT_TYPE) enum {
// What's included in the Script method output.
SQLDMOScript_None = 0x0000, // Skip all the flags from SQLDMO_SCRIPT_TYPE
SQLDMOScript_Default = 0x0004, // Object creation only
SQLDMOScript_Drops = 0x0001, // Include object drops
SQLDMOScript_ObjectPermissions = 0x0002, // Include object permissions
SQLDMOScript_PrimaryObject = 0x0004, // Include object creation
SQLDMOScript_ClusteredIndexes = 0x0008, // Include clustered index creation (table and view only)
SQLDMOScript_Triggers = 0x0010, // Include trigger creation (table and view only)
SQLDMOScript_DatabasePermissions = 0x0020, // Database (statement) permissions
SQLDMOScript_Permissions = 0x0022, // Both database and object permissions (for scripting users).
SQLDMOScript_ToFileOnly = 0x0040, // If not set, a string is returned (if file nonnull, both are done)
SQLDMOScript_Bindings = 0x0080, // Include rule/default bindings (table only)
SQLDMOScript_AppendToFile = 0x0100, // Append to output file if it already exists.
SQLDMOScript_NoDRI = 0x0200, // Do not include DRI (intended for use if targeting pre-6.0 server with scripts)
SQLDMOScript_UDDTsToBaseType = 0x0400, // Convert UserDefinedDatatypes to base type when creating columns (table only)
// 0x0800 available.
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -