/** EXEC p_DropIdx 'IDX_BAS_ASSISTANTDATAENTRY_NUM', 'T_BAS_ASSISTANTDATAENTRY'; **/
/** IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BAS_ASSISTANTDATAENTRY_NUM') CREATE UNIQUE INDEX IDX_BAS_ASSISTANTDATAENTRY_NUM ON T_BAS_ASSISTANTDATAENTRY ( FNUMBER ,FGROUPID );**/


/**EXEC p_DropIdx 'IDX_BAS_ASSISTANTDATAENTRY_NUM', 'T_BAS_ASSISTANTDATAENTRY';

IF NOT EXISTS(SELECT FNUMBER ,FGROUPID FROM T_BAS_ASSISTANTDATAENTRY GROUP BY FNUMBER ,FGROUPID HAVING COUNT(FNUMBER) > 1)**/
/**AND NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BAS_ASSISTANTDATAENTRY_NUM') CREATE UNIQUE INDEX IDX_BAS_ASSISTANTDATAENTRY_NUM ON T_BAS_ASSISTANTDATAENTRY ( FNUMBER ,FGROUPID );**/
