文章详情页
DB2获取当前用户表、字段、索引等详细信息
浏览:226日期:2023-03-24 09:22:30
获取所有表、字段、索引等详细信息
SELECT d.name tbName, COALESCE(d.remarks, "") tbDesc, a.name columnName, a.coltype columnType , decode(a.nulls,"Y","1","0") notNull, decode(a.identity,"Y","1","0") auto, a.longlength width, a.scale precision, COALESCE(a.remarks, "") comment, decode(n.unique_colcount,"1","1","0") unique, decode(n.uniquerule,"P","1","0") masterKey, COALESCE(n.name, "") indexName FROM sysibm.syscolumns a INNER JOIN sysibm.systables d on a.tbname=d.name LEFT JOIN sysibm.sysindexes n on n.tbname=d.name and SUBSTR(colnames,2)=a.name where d.type="T"and d.tbspace="USERSPACE1"
标签:
DB2
相关文章:
1. MySQL5.7 mysqldump备份与恢复的实现2. SqlServer 多种分页方式 详解(含简单速度测试)3. SQL Server跨服务器操作数据库的图文方法(LinkedServer)4. MySql使用mysqldump 导入与导出方法总结5. Mybatis传入List实现批量更新的示例代码6. html中select语句读取mysql表中内容7. Microsoft Office Access隐藏和显示字段的方法8. navicat for mysql导出数据库的方法9. How to access eclipse workspace?10. 快速解决mysql导出scv文件乱码、蹿行的问题
排行榜
