-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathQuery Vacia Tablas.sql
70 lines (70 loc) · 3.98 KB
/
Query Vacia Tablas.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
Use PramaSAS
go
EXEC sp_MSforeachtable @command1="ALTER TABLE ? NOCHECK CONSTRAINT ALL"
GO
delete from Articulos
Delete from Bancos
delete from Caja
delete from CajaAsociacionesCuentas
delete from CajaBancos
delete from CajaBcoPendientes
delete from CajaCredito
delete from CajaCuentas
delete from CajaDebito
delete from CajaEfectivo
delete from CajaMP
delete from CajaOtrosTipos
delete from CajaTransferencias
delete from Cheques
delete from ChequesOrdenesPago
delete from ChequesPropios
delete from ChequesRecibos
delete from ChequesTerceros
delete from Clientes
delete from CoeficientesArticulos
delete from ComprobantesCompras
delete from DetallePedidos
delete from DetallesComprobantesCompras
delete from DetallePresupuestos
delete from eFactura
delete from eFacturaDetalle
delete from MenuOpciones
delete from MenuOpcionesUser
delete from MenuUser
delete from MenuSistema
delete from MigrarCodigos
delete from OPDetallePropios
delete from OPDetalleTerceros
delete from OPDetalleTransferencias
delete from Pedidos
delete from Parametros
delete from Presupuestos
delete from Productos
delete from ProductosCompuestos
delete from ProductosGastosFijos
delete from ProductosInsumos
delete from Insumos
delete from InsumosCompuestos
delete from Proveedores
delete from PuntosVentaAFIP
delete from PuntosVentas
delete from Recibos
delete from RecibosDetalle
delete from Remitos
delete from RubrosArticulos
delete from SaldoCliProv
delete from StockFabricacion
delete from StockMovimientoInternoDetalle
delete from StockMovimientos
delete from StockMovimientosInternos
delete from SubrubrosArticulos
delete from Temporal_CargaDetPedido
delete from Temporal_CargaDetPresu
delete from Temporal_DetalleCheques
delete from Temporal_DetallePagoCaja
delete from Usuarios
GO
-- SQL enable all constraints - enable all constraints sql server
-- sp_MSforeachtable is an undocumented system stored procedure
EXEC sp_MSforeachtable @command1="ALTER TABLE ? CHECK CONSTRAINT ALL"
GO