Advertisement
econz

Firebird - Tags

Oct 19th, 2022
1,706
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.38 KB | Source Code | 0 0
  1. /* Criar Tags */
  2. ALTER USER SYSDBA SET tags (T1='Valor 1', T2='Valor 2');
  3. commit WORK;
  4.  
  5. /* Ver o conteúdo das tags */
  6. SELECT
  7.    U.SEC$USER_NAME,
  8.    A.SEC$KEY,
  9.    A.SEC$VALUE
  10. FROM SEC$USERS U LEFT JOIN SEC$USER_ATTRIBUTES A ON U.SEC$USER_NAME = A.SEC$USER_NAME
  11.  
  12.  
  13. /* Remover Tags */
  14. ALTER USER SYSDBA SET tags (DROP T1);
  15. ALTER USER SYSDBA SET tags (DROP T2);
  16. commit WORK;
  17.  
  18.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement