📄 atldbsch.h
字号:
TCHAR m_szDomainSchema[129];
TCHAR m_szDomainName[129];
TCHAR m_szDescription[129];
BEGIN_COLUMN_MAP(CColumnsInfo)
COLUMN_ENTRY(1, m_szTableCatalog)
COLUMN_ENTRY(2, m_szTableSchema)
COLUMN_ENTRY(3, m_szTableName)
COLUMN_ENTRY(4, m_szColumnName)
COLUMN_ENTRY(5, m_guidColumn)
COLUMN_ENTRY(6, m_nColumnPropID)
COLUMN_ENTRY(7, m_nOrdinalPosition)
COLUMN_ENTRY(8, m_bColumnHasDefault)
COLUMN_ENTRY(9, m_szColumnDefault)
COLUMN_ENTRY(10, m_nColumnFlags)
COLUMN_ENTRY(11, m_bIsNullable)
COLUMN_ENTRY(12, m_nDataType)
COLUMN_ENTRY(13, m_guidType)
COLUMN_ENTRY(14, m_nMaxLength)
COLUMN_ENTRY(15, m_nOctetLength)
COLUMN_ENTRY(16, m_nNumericPrecision)
COLUMN_ENTRY(17, m_nNumericScale)
COLUMN_ENTRY(18, m_nDateTimePrecision)
COLUMN_ENTRY(19, m_szCharSetCatalog)
COLUMN_ENTRY(20, m_szCharSetSchema)
COLUMN_ENTRY(21, m_szCharSetName)
COLUMN_ENTRY(22, m_szCollationCatalog)
COLUMN_ENTRY(23, m_szCollationSchema)
COLUMN_ENTRY(24, m_szCollationName)
COLUMN_ENTRY(25, m_szDomainCatalog)
COLUMN_ENTRY(26, m_szDomainSchema)
COLUMN_ENTRY(27, m_szDomainName)
COLUMN_ENTRY(28, m_szDescription)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CConstraintColumnUsageInfo
class CConstraintColumnUsageInfo
{
public:
// Constructor
CConstraintColumnUsageInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szTableCatalog[129];
TCHAR m_szTableSchema[129];
TCHAR m_szTableName[129];
TCHAR m_szColumnName[129];
GUID m_guidColumn;
ULONG m_nColumnPropID;
TCHAR m_szConstraintCatalog[129];
TCHAR m_szConstraintSchema[129];
TCHAR m_szConstraintName[129];
// Binding Maps
BEGIN_COLUMN_MAP(CConstraintColumnUsageInfo)
COLUMN_ENTRY(1, m_szTableCatalog)
COLUMN_ENTRY(2, m_szTableSchema)
COLUMN_ENTRY(3, m_szTableName)
COLUMN_ENTRY(4, m_szColumnName)
COLUMN_ENTRY(5, m_guidColumn)
COLUMN_ENTRY(6, m_nColumnPropID)
COLUMN_ENTRY(7, m_szConstraintCatalog)
COLUMN_ENTRY(8, m_szConstraintSchema)
COLUMN_ENTRY(9, m_szConstraintName)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CConstraintColumnUsageInfo
class CConstraintTableUsageInfo
{
public:
// Constructor
CConstraintTableUsageInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szTableCatalog[129];
TCHAR m_szTableSchema[129];
TCHAR m_szTableName[129];
TCHAR m_szConstraintCatalog[129];
TCHAR m_szConstraintSchema[129];
TCHAR m_szConstraintName[129];
// Binding Maps
BEGIN_COLUMN_MAP(CConstraintTableUsageInfo)
COLUMN_ENTRY(1, m_szTableCatalog)
COLUMN_ENTRY(2, m_szTableSchema)
COLUMN_ENTRY(3, m_szTableName)
COLUMN_ENTRY(4, m_szConstraintCatalog)
COLUMN_ENTRY(5, m_szConstraintSchema)
COLUMN_ENTRY(6, m_szConstraintName)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CForeignKeysInfo
class CForeignKeysInfo
{
public:
// Constructor
CForeignKeysInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szPKTableCatalog[129];
TCHAR m_szPKTableSchema[129];
TCHAR m_szPKTableName[129];
TCHAR m_szPKColumnName[129];
GUID m_guidPKColumn;
ULONG m_nPKColumnPropID;
TCHAR m_szFKTableCatalog[129];
TCHAR m_szFKTableSchema[129];
TCHAR m_szFKTableName[129];
TCHAR m_szFKColumnName[129];
GUID m_guidFKColumn;
ULONG m_nFKColumnPropID;
ULONG m_nOrdinal;
TCHAR m_szUpdateRule[12];
TCHAR m_szDeleteRule[12];
// Binding Info
BEGIN_COLUMN_MAP(CForeignKeysInfo)
COLUMN_ENTRY(1, m_szPKTableCatalog)
COLUMN_ENTRY(2, m_szPKTableSchema)
COLUMN_ENTRY(3, m_szPKTableName)
COLUMN_ENTRY(4, m_szPKColumnName)
COLUMN_ENTRY(5, m_guidPKColumn)
COLUMN_ENTRY(6, m_nPKColumnPropID)
COLUMN_ENTRY(7, m_szFKTableCatalog)
COLUMN_ENTRY(8, m_szFKTableSchema)
COLUMN_ENTRY(9, m_szFKTableName)
COLUMN_ENTRY(10, m_szFKColumnName)
COLUMN_ENTRY(11, m_guidFKColumn)
COLUMN_ENTRY(12, m_nFKColumnPropID)
COLUMN_ENTRY(13, m_nOrdinal)
COLUMN_ENTRY(14, m_szUpdateRule)
COLUMN_ENTRY(15, m_szDeleteRule)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CIndexesInfo
class CIndexesInfo
{
public:
// Constructors
CIndexesInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szTableCatalog[129];
TCHAR m_szTableSchema[129];
TCHAR m_szTableName[129];
TCHAR m_szIndexCatalog[129];
TCHAR m_szIndexSchema[129];
TCHAR m_szIndexName[129];
VARIANT_BOOL m_bPrimaryKey;
VARIANT_BOOL m_bUnique;
VARIANT_BOOL m_bClustered;
USHORT m_nType;
LONG m_nFillFactor;
LONG m_nInitialSize;
LONG m_nNulls;
VARIANT_BOOL m_bSortBookmarks;
VARIANT_BOOL m_bAutoUpdate;
LONG m_nNullCollation;
ULONG m_nOrdinalPosition;
TCHAR m_szColumnName[129];
GUID m_guidColumn;
ULONG m_nColumnPropID;
SHORT m_nCollation;
LONG m_nCardinality;
LONG m_nPages;
TCHAR m_szFilterCondition[129];
// Binding Maps
BEGIN_COLUMN_MAP(CIndexesInfo)
COLUMN_ENTRY(1, m_szTableCatalog)
COLUMN_ENTRY(2, m_szTableSchema)
COLUMN_ENTRY(3, m_szTableName)
COLUMN_ENTRY(4, m_szIndexCatalog)
COLUMN_ENTRY(5, m_szIndexSchema)
COLUMN_ENTRY(6, m_szIndexName)
COLUMN_ENTRY(7, m_bPrimaryKey)
COLUMN_ENTRY(8, m_bUnique)
COLUMN_ENTRY(9, m_bClustered)
COLUMN_ENTRY(10, m_nType)
COLUMN_ENTRY(11, m_nFillFactor)
COLUMN_ENTRY(12, m_nInitialSize)
COLUMN_ENTRY(13, m_nNulls)
COLUMN_ENTRY(14, m_bSortBookmarks)
COLUMN_ENTRY(15, m_bAutoUpdate)
COLUMN_ENTRY(16, m_nNullCollation)
COLUMN_ENTRY(17, m_nOrdinalPosition)
COLUMN_ENTRY(18, m_szColumnName)
COLUMN_ENTRY(19, m_guidColumn)
COLUMN_ENTRY(20, m_nColumnPropID)
COLUMN_ENTRY(21, m_nCollation)
COLUMN_ENTRY(22, m_nCardinality)
COLUMN_ENTRY(23, m_nPages)
COLUMN_ENTRY(25, m_szFilterCondition)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CKeyColumnUsageInfo
class CKeyColumnUsageInfo
{
public:
// Constructors
CKeyColumnUsageInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szConstraintCatalog[129];
TCHAR m_szConstraintSchema[129];
TCHAR m_szConstraintName[129];
TCHAR m_szTableCatalog[129];
TCHAR m_szTableSchema[129];
TCHAR m_szTableName[129];
TCHAR m_szColumnName[129];
GUID m_guidColumn;
ULONG m_nColumnPropID;
ULONG m_nOrdinalPosition;
// Binding Maps
BEGIN_COLUMN_MAP(CKeyColumnUsageInfo)
COLUMN_ENTRY(1, m_szConstraintCatalog)
COLUMN_ENTRY(2, m_szConstraintSchema)
COLUMN_ENTRY(3, m_szConstraintName)
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)
COLUMN_ENTRY(10, m_nOrdinalPosition)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CPrimaryKeyInfo
class CPrimaryKeyInfo
{
public:
// Constructors
CPrimaryKeyInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szTableCatalog[129];
TCHAR m_szTableSchema[129];
TCHAR m_szTableName[129];
TCHAR m_szColumnName[129];
GUID m_guidColumn;
ULONG m_nColumnPropID;
ULONG m_nOrdinal;
// Binding Maps
BEGIN_COLUMN_MAP(CPrimaryKeyInfo)
COLUMN_ENTRY(1, m_szTableCatalog)
COLUMN_ENTRY(2, m_szTableSchema)
COLUMN_ENTRY(3, m_szTableName)
COLUMN_ENTRY(4, m_szColumnName)
COLUMN_ENTRY(5, m_guidColumn)
COLUMN_ENTRY(6, m_nColumnPropID)
COLUMN_ENTRY(7, m_nOrdinal)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CProcedureColumnInfo
class CProcedureColumnInfo
{
public:
// Constructors
CProcedureColumnInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szCatalog[129];
TCHAR m_szSchema[129];
TCHAR m_szName[129];
TCHAR m_szColumnName[129];
GUID m_guidColumn;
ULONG m_nColumnPropID;
ULONG m_nRowsetNumber;
ULONG m_nOrdinalPosition;
VARIANT_BOOL m_bIsNullable;
USHORT m_nDataType;
GUID m_guidType;
ULONG m_nMaxLength;
ULONG m_nOctetLength;
USHORT m_nPrecision;
SHORT m_nScale;
TCHAR m_szDescription[129];
// Binding Maps
BEGIN_COLUMN_MAP(CProcedureColumnInfo)
COLUMN_ENTRY(1, m_szCatalog)
COLUMN_ENTRY(2, m_szSchema)
COLUMN_ENTRY(3, m_szName)
COLUMN_ENTRY(4, m_szColumnName)
COLUMN_ENTRY(5, m_guidColumn)
COLUMN_ENTRY(6, m_nColumnPropID)
COLUMN_ENTRY(7, m_nRowsetNumber)
COLUMN_ENTRY(8, m_nOrdinalPosition)
COLUMN_ENTRY(9, m_bIsNullable)
COLUMN_ENTRY(10, m_nDataType)
COLUMN_ENTRY(11, m_guidType)
COLUMN_ENTRY(12, m_nMaxLength)
COLUMN_ENTRY(13, m_nOctetLength)
COLUMN_ENTRY(14, m_nPrecision)
COLUMN_ENTRY(15, m_nScale)
COLUMN_ENTRY(16, m_szDescription)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CProcedureParameterInfo
class CProcedureParameterInfo
{
public:
// Constructors
CProcedureParameterInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szCatalog[129];
TCHAR m_szSchema[129];
TCHAR m_szName[129];
TCHAR m_szParameterName[129];
USHORT m_nOrdinalPosition;
USHORT m_nType;
VARIANT_BOOL m_bHasDefault;
TCHAR m_szDefault[129];
VARIANT_BOOL m_bIsNullable;
USHORT m_nDataType;
ULONG m_nMaxLength;
ULONG m_nOctetLength;
USHORT m_nPrecision;
SHORT m_nScale;
TCHAR m_szDescription[129];
// Binding Maps
BEGIN_COLUMN_MAP(CProcedureParameterInfo)
COLUMN_ENTRY(1, m_szCatalog)
COLUMN_ENTRY(2, m_szSchema)
COLUMN_ENTRY(3, m_szName)
COLUMN_ENTRY(4, m_szParameterName)
COLUMN_ENTRY(5, m_nOrdinalPosition)
COLUMN_ENTRY(6, m_nType)
COLUMN_ENTRY(7, m_bHasDefault)
COLUMN_ENTRY(8, m_szDefault)
COLUMN_ENTRY(9, m_bIsNullable)
COLUMN_ENTRY(10, m_nDataType)
COLUMN_ENTRY(11, m_nMaxLength)
COLUMN_ENTRY(12, m_nOctetLength)
COLUMN_ENTRY(13, m_nPrecision)
COLUMN_ENTRY(14, m_nScale)
COLUMN_ENTRY(15, m_szDescription)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CProcedureInfo
class CProcedureInfo
{
public:
// Constructors
CProcedureInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szCatalog[129];
TCHAR m_szSchema[129];
TCHAR m_szName[129];
SHORT m_nType;
TCHAR m_szDefinition[129];
TCHAR m_szDescription[129];
// Binding Maps
BEGIN_COLUMN_MAP(CProcedureInfo)
COLUMN_ENTRY(1, m_szCatalog)
COLUMN_ENTRY(2, m_szSchema)
COLUMN_ENTRY(3, m_szName)
COLUMN_ENTRY(4, m_nType)
COLUMN_ENTRY(5, m_szDefinition)
COLUMN_ENTRY(6, m_szDescription)
END_COLUMN_MAP()
};
///////////////////////////////////////////////////////////////////////////
// class CProviderTypeInfo
class CProviderTypeInfo
{
public:
// Constructors
CProviderTypeInfo()
{
memset(this, 0, sizeof(*this));
}
// Attributes
TCHAR m_szTypeName[129];
USHORT m_nDataType;
ULONG m_nColumnSize;
TCHAR m_szLiteralPrefix[129];
TCHAR m_szLiteralSuffix[129];
TCHAR m_szCreateParams[129];
VARIANT_BOOL m_bIsNullable;
VARIANT_BOOL m_bCaseSensitive;
ULONG m_nSearchable;
VARIANT_BOOL m_bUnsignedAttribute;
VARIANT_BOOL m_bFixedPrecScale;
VARIANT_BOOL m_bAutoUniqueValue;
TCHAR m_szLocalTypeName[129];
SHORT m_nMinScale;
SHORT m_nMaxScale;
GUID m_guidType;
TCHAR m_szTypeLib[129];
TCHAR m_szVersion[129];
VARIANT_BOOL m_bIsLong;
VARIANT_BOOL m_bBestMatch;
// Binding Maps
BEGIN_COLUMN_MAP(CProviderTypeInfo)
COLUMN_ENTRY(1, m_szTypeName)
COLUMN_ENTRY(2, m_nDataType)
COLUMN_ENTRY(3, m_nColumnSize)
COLUMN_ENTRY(4, m_szLiteralPrefix)
COLUMN_ENTRY(5, m_szLiteralSuffix)
COLUMN_ENTRY(6, m_szCreateParams)
COLUMN_ENTRY(7, m_bIsNullable)
COLUMN_ENTRY(8, m_bCaseSensitive)
COLUMN_ENTRY(9, m_nSearchable)
COLUMN_ENTRY(10, m_bUnsignedAttribute)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -