/* package whatever; // don't place package name! */
 
import java.util.*;
import java.lang.*;
import java.io.*;
import java.util.regex.*;
/* Name of the class has to be "Main" only if the class is public. */
class Ideone
{
	public static void main (String[] args) throws java.lang.Exception
	{
 
		String s = "создаем какую-то таблицу create table ururu ( id integer, name text ); и ещё одну таблицу create table anyanya ( id integer, ch integer, model text ); вот и всё";
		Pattern pattern = Pattern.compile("(?s)create table.*?\\);");
		Matcher matcher = pattern.matcher(s);
		List<String> lst = new ArrayList<>();
		while (matcher.find()){
			lst.add(matcher.group(0)); 
		} 
		System.out.println(lst); 
	}
}

LyogcGFja2FnZSB3aGF0ZXZlcjsgLy8gZG9uJ3QgcGxhY2UgcGFja2FnZSBuYW1lISAqLwoKaW1wb3J0IGphdmEudXRpbC4qOwppbXBvcnQgamF2YS5sYW5nLio7CmltcG9ydCBqYXZhLmlvLio7CmltcG9ydCBqYXZhLnV0aWwucmVnZXguKjsKLyogTmFtZSBvZiB0aGUgY2xhc3MgaGFzIHRvIGJlICJNYWluIiBvbmx5IGlmIHRoZSBjbGFzcyBpcyBwdWJsaWMuICovCmNsYXNzIElkZW9uZQp7CglwdWJsaWMgc3RhdGljIHZvaWQgbWFpbiAoU3RyaW5nW10gYXJncykgdGhyb3dzIGphdmEubGFuZy5FeGNlcHRpb24KCXsKCQkKCQlTdHJpbmcgcyA9ICLRgdC+0LfQtNCw0LXQvCDQutCw0LrRg9GOLdGC0L4g0YLQsNCx0LvQuNGG0YMgY3JlYXRlIHRhYmxlIHVydXJ1ICggaWQgaW50ZWdlciwgbmFtZSB0ZXh0ICk7INC4INC10YnRkSDQvtC00L3RgyDRgtCw0LHQu9C40YbRgyBjcmVhdGUgdGFibGUgYW55YW55YSAoIGlkIGludGVnZXIsIGNoIGludGVnZXIsIG1vZGVsIHRleHQgKTsg0LLQvtGCINC4INCy0YHRkSI7CgkJUGF0dGVybiBwYXR0ZXJuID0gUGF0dGVybi5jb21waWxlKCIoP3MpY3JlYXRlIHRhYmxlLio/XFwpOyIpOwoJCU1hdGNoZXIgbWF0Y2hlciA9IHBhdHRlcm4ubWF0Y2hlcihzKTsKCQlMaXN0PFN0cmluZz4gbHN0ID0gbmV3IEFycmF5TGlzdDw+KCk7CgkJd2hpbGUgKG1hdGNoZXIuZmluZCgpKXsKCQkJbHN0LmFkZChtYXRjaGVyLmdyb3VwKDApKTsgCgkJfSAKCQlTeXN0ZW0ub3V0LnByaW50bG4obHN0KTsgCgl9Cn0=