-- @@@ START COPYRIGHT @@@
--
-- Licensed to the Apache Software Foundation (ASF) under one
-- or more contributor license agreements.  See the NOTICE file
-- distributed with this work for additional information
-- regarding copyright ownership.  The ASF licenses this file
-- to you under the Apache License, Version 2.0 (the
-- "License"); you may not use this file except in compliance
-- with the License.  You may obtain a copy of the License at
--
--   http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing,
-- software distributed under the License is distributed on an
-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-- KIND, either express or implied.  See the License for the
-- specific language governing permissions and limitations
-- under the License.
--
-- @@@ END COPYRIGHT @@@
-- run showddl on tables (to show their triggers)

-- Suppress the Row Format information from the SHOWDDL output so
-- we don't have to update hundreds of existing Expected Results
-- files in our regression test suites.  'OFF' is the default.
control query default SQLMX_SHOWDDL_SUPPRESS_ROW_FORMAT 'ON';

LOG LOG_2_2_1 ;

--
-- from a new CI, should start with a "cold cache"

SET SCHEMA cat1.schm;

-- showddl tab1A;

-- showddl tab1B;

-- showddl cat2.schm.tab2A;

showddl cat3.schm.tab3A;

DROP TRIGGER cat1.schm.tr1;
DROP TRIGGER cat2.schm.tr2;
DROP TRIGGER cat1.schm.tr3;
DROP TRIGGER cat1.schm.tr4;
DROP TRIGGER cat3.schm.tab3A;

