define\s+([\w^\s]+)\s+having\s+fields\s*\((((.*?)\s+(.*?)\s*),?)*\);

Match example:
define table having fields(title1 type1, title2 type2, title3 type3);