📄 atldbsch.h
字号:
COLUMN_ENTRY(11, m_bFixedPrecScale)
COLUMN_ENTRY(12, m_bAutoUniqueValue)
COLUMN_ENTRY(13, m_szLocalTypeName)
COLUMN_ENTRY(14, m_nMinScale)
COLUMN_ENTRY(15, m_nMaxScale)
COLUMN_ENTRY(16, m_guidType)
COLUMN_ENTRY(17, m_szTypeLib)
COLUMN_ENTRY(18, m_szVersion)
COLUMN_ENTRY(19, m_bIsLong)
COLUMN_ENTRY(20, m_bBestMatch)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CReferentialConstraintInfo
class CReferentialConstraintInfo
{
public:
// Constructors
CReferentialConstraintInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szCatalog[129];
TCHAR m_szSchema[129];
TCHAR m_szName[129];
TCHAR m_szUniqueCatalog[129];
TCHAR m_szUniqueSchema[129];
TCHAR m_szUniqueName[129];
TCHAR m_szMatchOption[8];
TCHAR m_szUpdateRule[12];
TCHAR m_szDeleteRule[12];
TCHAR m_szDescription[129];
// Binding Maps
BEGIN_COLUMN_MAP(CReferentialConstraintInfo)
COLUMN_ENTRY(1, m_szCatalog)
COLUMN_ENTRY(2, m_szSchema)
COLUMN_ENTRY(3, m_szName)
COLUMN_ENTRY(4, m_szUniqueCatalog)
COLUMN_ENTRY(5, m_szUniqueSchema)
COLUMN_ENTRY(6, m_szUniqueName)
COLUMN_ENTRY(7, m_szMatchOption)
COLUMN_ENTRY(8, m_szUpdateRule)
COLUMN_ENTRY(9, m_szDeleteRule)
COLUMN_ENTRY(10, m_szDescription)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CSchemataInfo
class CSchemataInfo
{
public:
// Constructors
CSchemataInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szCatalog[129];
TCHAR m_szName[129];
TCHAR m_szOwner[129];
TCHAR m_szCharCatalog[129];
TCHAR m_szCharSchema[129];
TCHAR m_szCharName[129];
// Binding Maps
BEGIN_COLUMN_MAP(CSchemataInfo)
COLUMN_ENTRY(1, m_szCatalog)
COLUMN_ENTRY(2, m_szName)
COLUMN_ENTRY(3, m_szOwner)
COLUMN_ENTRY(4, m_szCharCatalog)
COLUMN_ENTRY(5, m_szCharSchema)
COLUMN_ENTRY(6, m_szCharName)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CSQLLangugageInfo
class CSQLLanguageInfo
{
public:
// Constructors
CSQLLanguageInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szSource[10];
TCHAR m_szYear[5];
TCHAR m_szConformance[13];
TCHAR m_szIntegrity[4];
TCHAR m_szImplementation[24];
TCHAR m_szBindingStyle[10];
TCHAR m_szProgrammingLanguage[10];
// Binding Maps
BEGIN_COLUMN_MAP(CSQLLanguageInfo)
COLUMN_ENTRY(1, m_szSource)
COLUMN_ENTRY(2, m_szYear)
COLUMN_ENTRY(3, m_szConformance)
COLUMN_ENTRY(4, m_szIntegrity)
COLUMN_ENTRY(5, m_szImplementation)
COLUMN_ENTRY(6, m_szBindingStyle)
COLUMN_ENTRY(7, m_szProgrammingLanguage)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CStatisticInfo
class CStatisticInfo
{
public:
// Constructors
CStatisticInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szTableCatalog[129];
TCHAR m_szTableSchema[129];
TCHAR m_szTableName[129];
LONG m_nCardinality;
// Binding Maps
BEGIN_COLUMN_MAP(CStatisticInfo)
COLUMN_ENTRY(1, m_szTableCatalog)
COLUMN_ENTRY(2, m_szTableSchema)
COLUMN_ENTRY(3, m_szTableName)
COLUMN_ENTRY(4, m_nCardinality)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CTableConstraintInfo
class CTableConstraintInfo
{
public:
// Constructors
CTableConstraintInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szCatalog[129];
TCHAR m_szSchema[129];
TCHAR m_szName[129];
TCHAR m_szTableCatalog[129];
TCHAR m_szTableSchema[129];
TCHAR m_szTableName[129];
TCHAR m_szType[12];
VARIANT_BOOL m_bIsDeferrable;
VARIANT_BOOL m_bInitiallyDeferred;
TCHAR m_szDescription[129];
// Binding Maps
BEGIN_COLUMN_MAP(CTableConstraintInfo)
COLUMN_ENTRY(1, m_szCatalog)
COLUMN_ENTRY(2, m_szSchema)
COLUMN_ENTRY(3, m_szName)
COLUMN_ENTRY(4, m_szTableCatalog)
COLUMN_ENTRY(5, m_szTableSchema)
COLUMN_ENTRY(6, m_szTableName)
COLUMN_ENTRY(7, m_szType)
COLUMN_ENTRY(8, m_bIsDeferrable)
COLUMN_ENTRY(9, m_bInitiallyDeferred)
COLUMN_ENTRY(10, m_szDescription)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CTablePrivilegeInfo
class CTablePrivilegeInfo
{
public:
// Constructors
CTablePrivilegeInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szGrantor[129];
TCHAR m_szGrantee[129];
TCHAR m_szCatalog[129];
TCHAR m_szSchema[129];
TCHAR m_szName[129];
TCHAR m_szType[12];
VARIANT_BOOL m_bIsGrantable;
// Binding Maps
BEGIN_COLUMN_MAP(CTablePrivilegeInfo)
COLUMN_ENTRY(1, m_szGrantor)
COLUMN_ENTRY(2, m_szGrantee)
COLUMN_ENTRY(3, m_szCatalog)
COLUMN_ENTRY(4, m_szSchema)
COLUMN_ENTRY(5, m_szName)
COLUMN_ENTRY(6, m_szType)
COLUMN_ENTRY(7, m_bIsGrantable)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CTableInfo
class CTableInfo
{
public:
// Constructors
CTableInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szCatalog[129];
TCHAR m_szSchema[129];
TCHAR m_szName[129];
TCHAR m_szType[129];
GUID m_guidTable;
TCHAR m_szDescription[129];
// Binding Map
BEGIN_COLUMN_MAP(CTableInfo)
COLUMN_ENTRY(1, m_szCatalog)
COLUMN_ENTRY(2, m_szSchema)
COLUMN_ENTRY(3, m_szName)
COLUMN_ENTRY(4, m_szType)
COLUMN_ENTRY(5, m_guidTable)
COLUMN_ENTRY(6, m_szDescription)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CTranslationInfo
class CTranslationInfo
{
public:
// Constructors
CTranslationInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szCatalog[129];
TCHAR m_szSchema[129];
TCHAR m_szName[129];
TCHAR m_szSourceCatalog[129];
TCHAR m_szSourceSchema[129];
TCHAR m_szSourceName[129];
TCHAR m_szTargetCatalog[129];
TCHAR m_szTargetSchema[129];
TCHAR m_szTargetName[129];
// Binding Maps
BEGIN_COLUMN_MAP(CTranslationInfo)
COLUMN_ENTRY(1, m_szCatalog)
COLUMN_ENTRY(2, m_szSchema)
COLUMN_ENTRY(3, m_szName)
COLUMN_ENTRY(4, m_szSourceCatalog)
COLUMN_ENTRY(5, m_szSourceSchema)
COLUMN_ENTRY(6, m_szSourceName)
COLUMN_ENTRY(7, m_szTargetCatalog)
COLUMN_ENTRY(8, m_szTargetSchema)
COLUMN_ENTRY(9, m_szTargetName)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CUsagePrivilegeInfo
class CUsagePrivilegeInfo
{
public:
// Constructors
CUsagePrivilegeInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szGrantor[129];
TCHAR m_szGrantee[129];
TCHAR m_szObjectCatalog[129];
TCHAR m_szObjectSchema[129];
TCHAR m_szObjectName[129];
TCHAR m_szObjectType[12];
TCHAR m_szPrivilegeType[6];
VARIANT_BOOL m_bIsGrantable;
// Binding Maps
BEGIN_COLUMN_MAP(CUsagePrivilegeInfo)
COLUMN_ENTRY(1, m_szGrantor)
COLUMN_ENTRY(2, m_szGrantee)
COLUMN_ENTRY(3, m_szObjectCatalog)
COLUMN_ENTRY(4, m_szObjectSchema)
COLUMN_ENTRY(5, m_szObjectName)
COLUMN_ENTRY(6, m_szObjectType)
COLUMN_ENTRY(7, m_szPrivilegeType)
COLUMN_ENTRY(8, m_bIsGrantable)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CViewColumnUsageInfo
class CViewColumnUsageInfo
{
public:
// Constructors
CViewColumnUsageInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szCatalog[129];
TCHAR m_szSchema[129];
TCHAR m_szName[129];
TCHAR m_szTableCatalog[129];
TCHAR m_szTableSchema[129];
TCHAR m_szTableName[129];
TCHAR m_szColumnName[129];
GUID m_guidColumn;
ULONG m_nColumnPropID;
// Binding Maps
BEGIN_COLUMN_MAP(CViewColumnUsageInfo)
COLUMN_ENTRY(1, m_szCatalog)
COLUMN_ENTRY(2, m_szSchema)
COLUMN_ENTRY(3, m_szName)
COLUMN_ENTRY(4, m_szTableCatalog)
COLUMN_ENTRY(5, m_szTableSchema)
COLUMN_ENTRY(6, m_szTableName)
COLUMN_ENTRY(7, m_szColumnName)
COLUMN_ENTRY(8, m_guidColumn)
COLUMN_ENTRY(9, m_nColumnPropID)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CViewTableUsageInfo
class CViewTableUsageInfo
{
public:
// Constructors
CViewTableUsageInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szCatalog[129];
TCHAR m_szSchema[129];
TCHAR m_szName[129];
TCHAR m_szTableCatalog[129];
TCHAR m_szTableSchema[129];
TCHAR m_szTableName[129];
// Binding Maps
BEGIN_COLUMN_MAP(CViewTableUsageInfo)
COLUMN_ENTRY(1, m_szCatalog)
COLUMN_ENTRY(2, m_szSchema)
COLUMN_ENTRY(3, m_szName)
COLUMN_ENTRY(4, m_szTableCatalog)
COLUMN_ENTRY(5, m_szTableSchema)
COLUMN_ENTRY(6, m_szTableName)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CViewInfo
class CViewInfo
{
public:
// Constructors
CViewInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szTableCatalog[129];
TCHAR m_szTableSchema[129];
TCHAR m_szTableName[129];
TCHAR m_szDefinition[129];
VARIANT_BOOL m_bCheckOption;
VARIANT_BOOL m_bIsUpdatable;
TCHAR m_szDescription[129];
// Binding Maps
BEGIN_COLUMN_MAP(CViewInfo)
COLUMN_ENTRY(1, m_szTableCatalog)
COLUMN_ENTRY(2, m_szTableSchema)
COLUMN_ENTRY(3, m_szTableName)
COLUMN_ENTRY(4, m_szDefinition)
COLUMN_ENTRY(5, m_bCheckOption)
COLUMN_ENTRY(6, m_bIsUpdatable)
COLUMN_ENTRY(7, m_szDescription)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// typedefs
typedef CRestrictions<CAccessor<CAssertionInfo>, 3, &DBSCHEMA_ASSERTIONS> CAssertions;
typedef CRestrictions<CAccessor<CCatalogInfo>, 1, &DBSCHEMA_CATALOGS > CCatalogs;
typedef CRestrictions<CAccessor<CCharacterSetInfo>, 3, &DBSCHEMA_CHARACTER_SETS> CCharacterSets;
typedef CRestrictions<CAccessor<CCheckConstraintInfo>, 3, &DBSCHEMA_CHECK_CONSTRAINTS> CCheckConstraints;
typedef CRestrictions<CAccessor<CCollationInfo>, 3, &DBSCHEMA_COLLATIONS> CCollations;
typedef CRestrictions<CAccessor<CColumnDomainUsageInfo>, 4, &DBSCHEMA_COLUMN_DOMAIN_USAGE> CColumnDomainUsage;
typedef CRestrictions<CAccessor<CColumnPrivilegeInfo>, 6, &DBSCHEMA_COLUMN_PRIVILEGES> CColumnPrivileges;
typedef CRestrictions<CAccessor<CColumnsInfo>, 4, &DBSCHEMA_COLUMNS> CColumns;
typedef CRestrictions<CAccessor<CConstraintColumnUsageInfo>,4, &DBSCHEMA_CONSTRAINT_COLUMN_USAGE> CConstraintColumnUsage;
typedef CRestrictions<CAccessor<CConstraintTableUsageInfo>, 3, &DBSCHEMA_CONSTRAINT_TABLE_USAGE> CConstraintTableUsage;
typedef CRestrictions<CAccessor<CForeignKeysInfo>, 6, &DBSCHEMA_FOREIGN_KEYS> CForeignKeys;
typedef CRestrictions<CAccessor<CIndexesInfo>, 5, &DBSCHEMA_INDEXES> CIndexes;
typedef CRestrictions<CAccessor<CKeyColumnUsageInfo>, 7, &DBSCHEMA_KEY_COLUMN_USAGE> CKeyColumnUsage;
typedef CRestrictions<CAccessor<CPrimaryKeyInfo>, 3, &DBSCHEMA_PRIMARY_KEYS> CPrimaryKeys;
typedef CRestrictions<CAccessor<CProcedureColumnInfo>, 4, &DBSCHEMA_PROCEDURE_COLUMNS> CProcedureColumns;
typedef CRestrictions<CAccessor<CProcedureParameterInfo>, 4, &DBSCHEMA_PROCEDURE_PARAMETERS> CProcedureParameters;
typedef CRestrictions<CAccessor<CProcedureInfo>, 4, &DBSCHEMA_PROCEDURES> CProcedures;
typedef CRestrictions<CAccessor<CProviderTypeInfo>, 2, &DBSCHEMA_PROVIDER_TYPES> CProviderTypes;
typedef CRestrictions<CAccessor<CReferentialConstraintInfo>,3, &DBSCHEMA_REFERENTIAL_CONSTRAINTS> CReferentialConstraints;
typedef CRestrictions<CAccessor<CSchemataInfo>, 3, &DBSCHEMA_SCHEMATA> CSchemata;
typedef CRestrictions<CAccessor<CSQLLanguageInfo>, 0, &DBSCHEMA_SQL_LANGUAGES> CSQLLanguages;
typedef CRestrictions<CAccessor<CStatisticInfo>, 3, &DBSCHEMA_STATISTICS> CStatistics ;
typedef CRestrictions<CAccessor<CTableConstraintInfo>, 7, &DBSCHEMA_TABLE_CONSTRAINTS> CTableConstraints;
typedef CRestrictions<CAccessor<CTablePrivilegeInfo>, 5, &DBSCHEMA_TABLE_PRIVILEGES> CTablePrivileges;
typedef CRestrictions<CAccessor<CTableInfo>, 4, &DBSCHEMA_TABLES> CTables;
typedef CRestrictions<CAccessor<CTranslationInfo>, 3, &DBSCHEMA_TRANSLATIONS> CTranslations;
typedef CRestrictions<CAccessor<CUsagePrivilegeInfo>, 6, &DBSCHEMA_USAGE_PRIVILEGES> CUsagePrivileges;
typedef CRestrictions<CAccessor<CViewColumnUsageInfo>, 3, &DBSCHEMA_VIEW_COLUMN_USAGE> CViewColumnUsage;
typedef CRestrictions<CAccessor<CViewTableUsageInfo>, 3, &DBSCHEMA_VIEW_TABLE_USAGE> CViewTableUsage;
typedef CRestrictions<CAccessor<CViewInfo>, 3, &DBSCHEMA_VIEWS> CViews;
///////////////////////////////////////////////////////////////////////////
}; //namespace ATL
#endif // __ATLDBSCH_H__
///////////////////////////////////////////////////////////////////////////
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -