Operation Details
Description: Searches for schemas with the specified display name. The search is a wildcard search and is case insensitive. The schema text is not returned.
Sterotype: nsmulti
SQL 
SELECT
  s.schemaName,
  CASE
    WHEN t.localizedText IS NULL 
    THEN s.schemaName 
    ELSE t.localizedText 
  END AS schemaDisplayName,
  s.schemaType
INTO
  :schemaName,
  :schemaDisplayName,
  :schemaType
FROM
  DataStoreSchema s LEFT OUTER JOIN DataStoreSchemaTranslation t 
  ON t.schemaName = s.schemaName 
  AND t.type = :type
  AND t.localeIdentifier = :localeIdentifier
WHERE
 UPPER(t.localizedText) LIKE :localizedText
ORDER BY schemaDisplayName ASC