Subversion Repositories Integrator Subversion

Rev

Rev 410 | Rev 595 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 410 Rev 471
Line 1... Line 1...
1 
SET search_path = sc_sec;
1 
SET search_path = sc_sec;
- 
 
 2 

          

          

            -
            
 

            3
            
DROP TABLE TABLE_NAME;


          

          

            2
            

            4
            

          

          

            3
            
ALTER TABLE sec_cliente RENAME COLUMN dsc_cpf TO dsc_cpf_cnpj;


            5
            
ALTER TABLE sec_cliente RENAME COLUMN dsc_cpf TO dsc_cpf_cnpj;


          

          

            4
            
ALTER TABLE sec_produto DROP COLUMN cod_ncm;


            6
            
ALTER TABLE sec_produto DROP COLUMN cod_ncm;


          

          

            5
            
ALTER TABLE sec_nota_fiscal ADD COLUMN dsc_obs_venda VARCHAR(300) NULL;


            7
            
ALTER TABLE sec_nota_fiscal ADD COLUMN dsc_obs_venda VARCHAR(300) NULL;


          

          

            6
            

            8