OnlineDB/EcalCondDB/sql/show_db.sql - master - githubmirror/cmssw

OnlineDB/EcalCondDB/sql/show_db.sql

12 строк549 B

Giulio Eulisse

Snapshot of CMSSW_6_2_0_pre8.

26 июн 2013, 18:12

26 июн 2013, 18:12214ab73

/* Show all the database objects */

set pagesize 10000;
set linesize 10000;

SELECT table_name FROM user_tables ORDER BY table_name;
SELECT view_name FROM user_views;
SELECT sequence_name FROM user_sequences ORDER BY sequence_name;
SELECT procedure_name, object_name FROM user_procedures ORDER BY procedure_name;
SELECT object_name AS FUNCTION FROM user_objects WHERE object_type = 'FUNCTION';
SELECT trigger_name, table_name FROM user_triggers WHERE trigger_name NOT LIKE 'BIN%' ORDER BY trigger_name;
SELECT db_link, username FROM user_db_links;