public string AlterXPKIndexSQL(IndexDefInfo indexInfo)
{
string strNames = indexInfo.CreateFieldsNameLnList();
string strSQL = ("ALTER TABLE ");
strSQL += indexInfo.m_strTable;
strSQL += (" ADD ");
strSQL += PlatformCreateContraintSQL(strNames, indexInfo.m_strName, indexInfo.m_bPrimary);
return(strSQL);
}
public string CreateIndexSQL(IndexDefInfo indexInfo)
{
string strNames = indexInfo.CreateFieldsNameLnList();
string strSQL = ("CREATE INDEX ");
strSQL += indexInfo.m_strName;
strSQL += (" ON ");
strSQL += indexInfo.m_strTable;
strSQL += (" (");
strSQL += strNames;
strSQL += (")");
return(strSQL);
}
