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); }