21/11/2011, 15:10
|
| | Fecha de Ingreso: noviembre-2011
Mensajes: 1
Antigüedad: 13 años Puntos: 0 | |
SQL state: 3F000 codigo no se lo que es Ayuda con este codigo no puedo ejecutar este SQL en Postgresql
Si me pueden ayudar muchas gracias. esto lo hice con un programa que lo saca en en codigo SQL.
Les envio el codigo:
drop index CCEINDEX;
alter table TBL_AC_COST_CENTER
drop constraint PK_TBL_AC_COST_CENTER;
drop table GCADMIN.TBL_AC_COST_CENTER;
drop index ADDINDEX;
alter table TBL_FW_ADDRESS
drop constraint PK_TBL_FW_ADDRESS;
drop table GCADMIN.TBL_FW_ADDRESS;
drop index APPUNIQUE02;
drop index APPUNIQUE01;
drop index APPINDEX;
alter table TBL_FW_APLICATION
drop constraint PK_TBL_FW_APLICATION;
drop table GCADMIN.TBL_FW_APLICATION;
drop index CITINDEX;
alter table TBL_FW_CITY
drop constraint PK_TBL_FW_CITY;
drop table GCADMIN.TBL_FW_CITY;
drop index CSTUNIQUE;
drop index CSTINDEX;
alter table TBL_FW_CIVILSTATE
drop constraint PK_TBL_FW_CIVILSTATE;
drop table TBL_FW_CIVILSTATE;
drop index COMINDEX;
alter table TBL_FW_COMMUNE
drop constraint PK_TBL_FW_COMMUNE;
drop table GCADMIN.TBL_FW_COMMUNE;
drop index CTYID;
alter table TBL_FW_CONTACT_TYPE
drop constraint PK_TBL_FW_CONTACT_TYPE;
drop table GCADMIN.TBL_FW_CONTACT_TYPE;
drop index COUUNIQUE02;
drop index COUUNIQUE01;
drop index COUINDEX;
alter table TBL_FW_COUNTRY
drop constraint PK_TBL_FW_COUNTRY;
drop table GCADMIN.TBL_FW_COUNTRY;
drop index ESTINDEX;
alter table TBL_FW_ESTATE
drop constraint PK_TBL_FW_ESTATE;
drop table GCADMIN.TBL_FW_ESTATE;
drop index MAIINDEX;
alter table TBL_FW_MAIL
drop constraint PK_TBL_FW_MAIL;
drop table GCADMIN.TBL_FW_MAIL;
drop index NAUINDEX02;
drop index NAUINDEX01;
alter table TBL_FW_NAV_APP_USE
drop constraint PK_TBL_FW_NAV_APP_USE;
drop table GCADMIN.TBL_FW_NAV_APP_USE;
drop index NNRINDEX02;
drop index NNRINDEX01;
alter table TBL_FW_NAV_NAU_ROL
drop constraint PK_TBL_FW_NAV_NAU_ROL;
drop table GCADMIN.TBL_FW_NAV_NAU_ROL;
drop index NPAINDEX;
alter table TBL_FW_NAV_PER_ADD
drop constraint PK_TBL_FW_NAV_PER_ADD;
drop table GCADMIN.TBL_FW_NAV_PER_ADD;
drop index PERINDEX02;
drop index PERINDEX01;
alter table TBL_FW_PERSON
drop constraint PK_TBL_FW_PERSON;
drop table GCADMIN.TBL_FW_PERSON;
drop index PHOINDEX;
alter table TBL_FW_PHONE
drop constraint PK_TBL_FW_PHONE;
drop table GCADMIN.TBL_FW_PHONE;
drop index RELINDEX02;
drop index RELINDEX01;
alter table TBL_FW_RELATIONSHIP
drop constraint PK_TBL_FW_RELATIONSHIP;
drop table GCADMIN.TBL_FW_RELATIONSHIP;
drop index ROLUNIQUE02;
drop index ROLUNIQUE01;
drop index ROLINDEX;
alter table TBL_FW_ROLE
drop constraint PK_TBL_FW_ROLE;
drop table GCADMIN.TBL_FW_ROLE;
drop index TREUNIQUE;
drop index TREINDEX;
alter table TBL_FW_TYPE_RELATIONSHIP
drop constraint PK_TBL_FW_TYPE_RELATIONSHIP;
drop table GCADMIN.TBL_FW_TYPE_RELATIONSHIP;
drop index USEINDEX02;
drop index USEINDEX01;
alter table TBL_FW_USER
drop constraint PK_TBL_FW_USER;
drop table GCADMIN.TBL_FW_USER;
drop index AVBINDEX02;
drop index AVBINDEX01;
alter table TBL_MV_ASSIGNED_VEHICLE_BENEFIT
drop constraint PK_TBL_MV_ASSIGNED_VEHICLE_BEN;
drop table GCADMIN.TBL_MV_ASSIGNED_VEHICLE_BENEFIT;
drop index ETVINDEX;
alter table TBL_MV_EVENT_TYPE_VEHICLE
drop constraint PK_TBL_MV_EVENT_TYPE_VEHICLE;
drop table GCADMIN.TBL_MV_EVENT_TYPE_VEHICLE;
drop index EVVINDEX03;
drop index EVVINDEX02;
drop index EVVINDEX01;
alter table TBL_MV_EVENT_VEHICLE
drop constraint PK_TBL_MV_EVENT_VEHICLE;
drop table GCADMIN.TBL_MV_EVENT_VEHICLE;
drop index INCINDEX;
alter table TBL_MV_INSURANCE_COMPANY
drop constraint PK_TBL_MV_INSURANCE_COMPANY;
drop table GCADMIN.TBL_MV_INSURANCE_COMPANY;
drop index ICOINDEX02;
drop index ICOINDEX01;
alter table TBL_MV_INSURANCE_CONTRACT
drop constraint PK_TBL_MV_INSURANCE_CONTRACT;
drop table GCADMIN.TBL_MV_INSURANCE_CONTRACT;
drop index INTINDEX;
alter table TBL_MV_INSURANCE_TYPE
drop constraint PK_TBL_MV_INSURANCE_TYPE;
drop table GCADMIN.TBL_MV_INSURANCE_TYPE;
drop index NERINDEX02;
drop index NERINDEX01;
alter table TBL_MV_NAV_EMP_ROB
drop constraint PK_TBL_MV_NAV_EMP_ROB;
drop table GCADMIN.TBL_MV_NAV_EMP_ROB;
drop index ROBINDEX;
alter table TBL_MV_RANGE_OF_VEHICLE_BENEFIT
drop constraint PK_TBL_MV_RANGE_OF_VEHICLE_BEN;
drop table GCADMIN.TBL_MV_RANGE_OF_VEHICLE_BENEFIT;
drop index VEHINDEX01;
alter table TBL_MV_VEHICLE
drop constraint PK_TBL_MV_VEHICLE;
drop table GCADMIN.TBL_MV_VEHICLE;
drop index VBRINDEX;
alter table TBL_MV_VEHICLE_BRAND
drop constraint PK_TBL_MV_VEHICLE_BRAND;
drop table GCADMIN.TBL_MV_VEHICLE_BRAND;
drop index VDAINDEX02;
drop index VDAINDEX01;
alter table TBL_MV_VEHICLE_DEBT_ALLOCATION
drop constraint PK_TBL_MV_VEHICLE_DEBT_ALLOCAT;
drop table GCADMIN.TBL_MV_VEHICLE_DEBT_ALLOCATION;
drop index TOVINDEX;
alter table TBL_MV_VEHICLE_TYPE
drop constraint PK_TBL_MV_VEHICLE_TYPE;
drop table GCADMIN.TBL_MV_VEHICLE_TYPE;
drop index TBEID;
alter table TBL_PM_BENEFIT_TYPE
drop constraint PK_TBL_PM_BENEFIT_TYPE;
drop table GCADMIN.TBL_PM_BENEFIT_TYPE;
drop index CONINDEX;
alter table TBL_PM_CONTRACT
drop constraint PK_TBL_PM_CONTRACT;
drop table GCADMIN.TBL_PM_CONTRACT;
drop index DEPINDEX;
alter table TBL_PM_DEPARTMENT
drop constraint PK_TBL_PM_DEPARTMENT;
drop table GCADMIN.TBL_PM_DEPARTMENT;
drop index EMPINDEX03;
drop index EMPINDEX02;
drop index EMPINDEX01;
alter table TBL_PM_EMPLOYEE
drop constraint PK_TBL_PM_EMPLOYEE;
drop table GCADMIN.TBL_PM_EMPLOYEE;
drop index EVEINDEX02;
drop index EVEINDEX01;
alter table TBL_PM_EVENTUALITY
drop constraint PK_TBL_PM_EVENTUALITY;
drop table GCADMIN.TBL_PM_EVENTUALITY;
drop index HOLINDEX;
alter table TBL_PM_HOLIDAY
drop constraint PK_TBL_PM_HOLIDAY;
drop table GCADMIN.TBL_PM_HOLIDAY;
drop index NTEINDEX02;
drop index NTEINDEX01;
alter table TBL_PM_NAV_TPE_EMP
drop constraint PK_TBL_PM_NAV_TPE_EMP;
drop table GCADMIN.TBL_PM_NAV_TPE_EMP;
drop index POSINDEX;
alter table TBL_PM_POSITIONS
drop constraint PK_TBL_PM_POSITIONS;
drop table GCADMIN.TBL_PM_POSITIONS;
drop index TCOINDEX;
alter table TBL_PM_TYPE_CONTRACT
drop constraint PK_TBL_PM_TYPE_CONTRACT;
drop table GCADMIN.TBL_PM_TYPE_CONTRACT;
drop index TOEINDEX;
alter table TBL_PM_TYPE_OF_EVENT
drop constraint PK_TBL_PM_TYPE_OF_EVENT;
drop table GCADMIN.TBL_PM_TYPE_OF_EVENT;
drop user GCADMIN;
drop domain T_BOOL;
drop domain T_CHAR;
drop domain T_CODE;
drop domain T_DATE;
drop domain T_ID;
drop domain T_INT;
drop domain T_NAME;
drop domain T_NUMBER;
drop domain T_TEXT; |