sanluan / dmdialect Goto Github PK

public String getQuerySequencesString() {
	//return "select name from sysobjects where type$ = 'SCHOBJ' and subtype$ = 'SEQ';";
}

@Override
public String getQuerySequencesString() {
	//return "select name from sysobjects where type$ = 'SCHOBJ' and subtype$ = 'SEQ';";
	return "select \n" +
			"d.SEQUENCE_NAME AS sequence_name,\n" +
			"'' as  sequence_catalog,\n" +
			"d.SEQUENCE_OWNER AS sequence_schema,\n" +
			"d.MIN_VALUE AS start_value,\n" +
			"d.MIN_VALUE AS minimum_value,\n" +
			"d.MAX_VALUE AS maximum_value,\n" +
			"d.INCREMENT_BY AS increment\n" +
			" from sysobjects a \n" +
			"inner join all_objects b on a.SCHID = b.OBJECT_ID AND b.object_type = 'SCH' \n" +
			"inner join ALL_USERS c on b.object_name = c.username\n" +
			"inner join ALL_SEQUENCES d on a.NAME = d.SEQUENCE_NAME AND c.username = d.SEQUENCE_OWNER  \n" +
			"where a.type$ = 'SCHOBJ' and a.subtype$ = 'SEQ' ";
}