oracle判断表是否存在 如果有就删除表.

select table_name  from all_tables where table_name ='LBIPDOCUMENTTYPE';
create or replace procedure super.proc_droptable
is v_tablename varchar2(200);
begin
  select table_name INTO v_tablename from all_tables where table_name ='LBIPDOCUMENTTYPE';
 
   if v_tablename is not null then
    execute immediate 'drop table LBIPDOCUMENTTYPE';
     commit;
   end if;
exception when others then
     commit;
end;

exec super.proc_droptable;

commit;

CREATE TABLE LBIPDOCUMENTTYPE
(
  ID              VARCHAR2(64 BYTE),
  TYPENAME        VARCHAR2(200 BYTE),
  IMAGEPATH       VARCHAR2(300 BYTE),
  ONOPERATION     INTEGER,
  IMGEUPLOADPATH  VARCHAR2(700 BYTE),
  REMARK          VARCHAR2(400 BYTE),
  EXTENSIONNAME   VARCHAR2(64 BYTE)
)
TABLESPACE LEAPV3
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            MINEXTENTS       1
            MAXEXTENTS       2147483645
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;

ALTER TABLE LBIPDOCUMENTTYPE ADD (
  PRIMARY KEY
 (ID)
    USING INDEX
    TABLESPACE LEAPV3
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          64K
                MINEXTENTS       1
                MAXEXTENTS       2147483645
                PCTINCREASE      0
               ));

   commit;

==========================================================

sql的表达方式

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LBIPDOCUMENTTYPE]') AND type in (N'U'))
DROP TABLE [dbo].LBIPDOCUMENTTYPE
CREATE TABLE LBIPDOCUMENTTYPE
(
  ID              VARCHAR(64),
  TYPENAME        VARCHAR(200),
  IMAGEPATH       VARCHAR(300),
  ONOPERATION     int,
  IMGEUPLOADPATH  VARCHAR(700),
  REMARK          VARCHAR(400),
  EXTENSIONNAME   VARCHAR(64),
   CONSTRAINT [PK_LBIPDOCUMENTTYPE] PRIMARY KEY CLUSTERED
(
 [ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

go