Quelltext der Seite Delete UserOptions macht Export Pläne schneller.sql

aus File "delete_UserOptions__macht_Export_Pläne_schneller.sql"

'''ACHTUNG''' - Nach Ausführung dieses Skripts die '''Datenbank nicht mehr für einen AXML-Export verwenden''', da die Nebeneffekte unbekannt sind.

 delete from DANStationUser where IdUserUsername not like 'BIT %';
 delete from DANStationUserPrintOptionen where IdStationUserUserUsername not like 'BIT %';
 delete from DANStationUserSuSp where IdSchemaStationUserUserUsernam not like 'BIT %';
 delete from DANStationUserSuSpSchema where IdStationUserUserUsername not like 'BIT %';
 delete from DANUser where IdUsername not like 'BIT %';
 delete from DANUserOption where IdUserUsername not like 'BIT %';
 delete from DANUserPrivileg where IdUserUsername not like 'BIT %';
 commit;


zurück zu [[V70Datenmigration]]