本文提供了一系列SQL查询语句，用于检查DB2数据库中的各种对象，包括用户表、表列信息、序列、触发器及存储过程等。这些查询有助于了解数据库结构并进行维护。
-- 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>'
扫一扫
2929
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
