--
--
--                                GBase.
-- 
--                           PROPRIETARY DATA
--
--  Licensed Material - Property Of GBase
-- 
--  "Restricted Materials of GBase"
-- 
--  GBase Client SDK
-- 
--  Copyright GBASE  2007. All rights reserved.
-- 
-- ****************************************************************************
--

-- doledbp.sql - drops GBasedbt OLE DB Provider support objects
-- DBA runs this file to drop the provider support objects in sysmaster

--Run the whole thing in transaction
Begin work;

drop procedure gbasedbt.oledbmakebool;
drop procedure gbasedbt.oledbidxunique;
drop procedure gbasedbt.oledbidxcoll;
drop procedure gbasedbt.oledbidxnulls;
drop procedure gbasedbt.oledbidxintegr;
drop procedure gbasedbt.oledbidxclustered;
drop procedure gbasedbt.oledbmakexstid;
drop procedure gbasedbt.oledbmakexstid1;
drop procedure gbasedbt.oledbMatchQualInfo;
drop procedure gbasedbt.oledbcolscale;
drop procedure gbasedbt.oledbcolscale1;
drop procedure gbasedbt.oledbcolprec;
drop procedure gbasedbt.oledbcollen;
drop procedure gbasedbt.oledbcolnullable;
drop procedure gbasedbt.oledbcoldef;
drop procedure gbasedbt.oledbisnotnull;
drop procedure gbasedbt.oledbissystab;
drop procedure gbasedbt.oledbconstrrule;
drop procedure gbasedbt.oledbkeypart;
drop procedure gbasedbt.oledbcolflags;
drop procedure gbasedbt.oledbnvl;
drop procedure gbasedbt.oledbwithcheck;
drop procedure gbasedbt.oledbhaswcheck;
drop procedure gbasedbt.oledbconcatview;
drop procedure gbasedbt.oledbconcatproc;
drop procedure gbasedbt.oledbconcatcheck;
drop table gbasedbt.oledbordinals;
drop table gbasedbt.oledbusagetypes;
drop table gbasedbt.oledbprivtypes;
drop table gbasedbt.oledbconstrtypes;
drop table gbasedbt.oledbconstrdefers;
drop table gbasedbt.oledbtypes;
drop table gbasedbt.oledbbmk;
drop table gbasedbt.oledbtabtypes;
drop table gbasedbt.oledboleobjects;
drop table gbasedbt.oledbversion;
drop procedure gbasedbt.oledbtype1;


-- Commit the work if everthing goes fine
commit;
