DB2 system table resource
来源:互联网 发布:华为交换机查mac ip 编辑:程序博客网 时间:2024/05/17 03:21
-- CHECK USER TABLES
SELECT NAME FROM SYSIBM.SYSTABLES WHERE CREATEDBY = CURRENT_SCHEMA
SELECT NAME FROM SYSIBM.SYSTABLES WHERE CREATEDBY = '<USERNAME>'
-- CHECK TABLE COLUMNS INFORMATION
SELECT NAME, COLTYPE, LENGTH FROM SYSIBM.SYSCOLUMNS WHERE TBNAME = 'EMPLOYEE' AND TBCREATOR = CURRENT_SCHEMA
-- CHECK SEQUENCES
SELECT NAME FROM SYSIBM.SYSSEQUENCES WHERE CREATEDBY = CURRENT_SCHEMA
-- CHECK TRIGGERS
SELECT NAME FROM SYSIBM.SYSTRIGGERS WHERE CREATEDBY = CURRENT_SCHEMA
-- CHECK PROCEDURE AND FUNCTION
SELECT NAME FROM SYSIBM.SYSROUTINES WHERE ROUTINETYPE = 'P' AND CREATEDBY = CURRENT_SCHEMA
SELECT NAME FROM SYSIBM.SYSROUTINES WHERE ROUTINETYPE = 'F' AND CREATEDBY = CURRENT_SCHEMA
-- CHECK INDEXES
SELECT NAME FROM SYSIBM.SYSINDEXES WHERE TBNAME = '<TABLENAME>'
0 0
- DB2 system table resource
- DB2 Resource
- Resource System
- DB2 REORG TABLE
- db2 truncate table
- DB2 check table definition
- system resource monitor
- Qt: Resource System
- Azure VM System Resource
- DB2 错误解决方案: SQL1585N A system temporary table space with sufficient page size does not exist. SQ
- DB2中的table join方法
- db2:根据TABLEID找table
- DB2的create table like
- DB2 mainframe create table DDL
- DB2 mainframe table operation DML
- Generate DB2 table definition COPYBOOK
- Linux System Call Table
- innodb system table
- 17. Letter Combinations of a Phone Number
- 15 个 Android 通用流行框架大全(归类)
- 单链表的基本运算
- ~~~初学者之div+css简介~~~
- 【11月11日 】排序算法续--快速排序+彩蛋一
- DB2 system table resource
- gcc的三级优化
- web安全书籍整理
- 输入一个矩阵,按照从外向里以顺时针的顺序依次打印出每一个数字,例如,如果输入如下矩阵: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 则依次打印出数字1,2,3,4,8
- Angular2 从0到1 (一)
- 读书笔记(6) 计算机基础
- TCP/IP协议学习(2)-IP协议、ARP协议
- ssh中处理事务的几种方式
- c++本程序如何调用执行另一个程序WinExce,ShellExecute,CreateProcess