Schema_uuid

SQL

FUNCTION Schema_uuid(IN schema_name CHAR(31)) RETURNS BINARY(12);


Parametry

schema_name
japplication name


Od verze

8.1

Popis

This function returns the binary identifier (UUID) of the schema_name application. If the parameter is NULL or empty string, the function will return the UUID of the currently opened application. If a invalid name is specified, the function will return NULL.



Návratová hodnota

Returns the application UUID or NULL.



Příklad

Get the list of tables of the current application

SELECT Tabtab.tab_name
FROM Tabtab
WHERE Tabtab.apl_uuid=Schema_uuid(NULL)

Viz