econz icon

Firebird - Tags

econz | PRO | 10/19/22 02:49:35 PM UTC | 0 ⭐ | 9322 👁️ | Never ⏰ | []
SQL |

380 B

|

Source Code

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
/* Criar Tags */
ALTER USER SYSDBA SET tags (T1='Valor 1', T2='Valor 2');
commit WORK;
 
/* Ver o conteúdo das tags */
SELECT
   U.SEC$USER_NAME,
   A.SEC$KEY,
   A.SEC$VALUE
FROM SEC$USERS U LEFT JOIN SEC$USER_ATTRIBUTES A ON U.SEC$USER_NAME = A.SEC$USER_NAME
 
 
/* Remover Tags */
ALTER USER SYSDBA SET tags (DROP T1);
ALTER USER SYSDBA SET tags (DROP T2);
commit WORK;
 
 

Comments

  • icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎

    
    
    

    

            
    • 
            
            
  • 
                
    
                    
    
                         icon
                    
    
                    
    
                        
                        
                        
                    
    
                    
    
                        
                        01/01/70 12:00:00 AM UTC
                        
                    
    
                
    
                

    
    
    
        
    
            Plain Text
            |
            
    0 B
    
            
            |
            
     👍
    
            /
            
     👎
    
        
    
        
    
    
    
    
        
    
    
    

    

            
    •