Gestione dossier

Gestione dossier

Eliminazione dossier

Detto ZZZ il nome del dossier da eliminare:

1. Da GESADS selezionare il dossier ZZZ e cliccare sul pulsante Elimina
2. Andare sul server applicativo (srvx3), nella cartella Folders (C:\SAGE\SAGEX3V6\X3V6\Folders)
   • rimuovere la cartella ZZZ
   • rimuovere la cartella X3_PUB\ZZZ
3. Eseguire i comandi sql seguenti (per connettersi il nome istanza è SERVER\X3V6):

use [x3v6]

DECLARE @table_schema varchar(100)
       ,@table_name varchar(100)
       ,@constraint_schema varchar(100)
       ,@constraint_name varchar(100)
       ,@cmd nvarchar(200)

--  Inserire il nome dello schema da eliminare 
SET @table_schema = 'TEST'


--
-- drop all VIEW
--
DECLARE @table_cursor CURSOR 
SET @table_cursor = CURSOR FOR  
  select TABLE_NAME
  from INFORMATION_SCHEMA.TABLES
  where 
		 TABLE_TYPE = 'VIEW'
	 and TABLE_SCHEMA = @table_schema
  order by TABLE_NAME   
  
OPEN @table_cursor
FETCH NEXT FROM @table_cursor INTO  @table_name

print 'elimino viste'  
WHILE @@FETCH_STATUS = 0 
BEGIN
     SELECT @cmd = 'DROP TABLE [' + @table_schema + '].[' + @table_name + ']'
     print @cmd
     --EXEC sp_executesql @cmd
  
  
     FETCH NEXT FROM @table_cursor INTO  @table_name
END
  
CLOSE @table_cursor 
DEALLOCATE @table_cursor


--
-- drop all TABLE
--
SET @table_cursor = CURSOR FOR  select TABLE_NAME
    from INFORMATION_SCHEMA.TABLES
  where 
		 TABLE_TYPE = 'BASE TABLE'
	 and TABLE_SCHEMA = @table_schema 
  order by TABLE_NAME 

OPEN @table_cursor
FETCH NEXT FROM @table_cursor INTO  @table_name

print 'Elimino TAbelle'  

WHILE @@FETCH_STATUS = 0 
BEGIN
     SELECT @cmd = 'DROP TABLE [' + @table_schema + '].[' + @table_name + ']'
     print @cmd
     --EXEC sp_executesql @cmd
  
  
     FETCH NEXT FROM @table_cursor INTO  @table_name
END
  
CLOSE @table_cursor 
DEALLOCATE @table_cursor


--
-- Cancellazione Schema
--
SELECT @cmd = 'DROP SCHEMA ' + @table_schema  
--EXEC sp_executesql @cmd

Eseguire le cancellazione seguenti:

select * from  X3.ADOSACT where DOSSIER_0  like 'TEST%' 
delete         X3.ADOSACT where DOSSIER_0  like 'TEST%' 

select * from  X3.ADOSDIM where DOSSIER_0  like 'TEST%' 
delete         X3.ADOSDIM where DOSSIER_0  like 'TEST%' 

select * from dbo.SS_SEQUENCE where usr  like 'TEST%' 
delete        dbo.SS_SEQUENCE where usr  like 'TEST%'