达梦数据库入门基础|C/S框架网

Server=localhost;Port=5236;Database=CSFramework_WebAPI_V3_Log;Uid=SYSDBA;Pwd=123456;

--查询所有数据库名, 查询用户名及模式
SELECT DISTINCT DBNAME FROM (SELECT OBJECT_NAME AS DBNAME FROM ALL_OBJECTS WHERE OBJECT_TYPE='SCH' UNION SELECT USERNAME AS DBNAME FROM ALL_USERS) T ORDER BY DBNAME

--查询数据库
select * from v$Database

--查询所有存储过程
SELECT * FROM USER_PROCEDURES order by OBJECT_NAME;

--查询用户自定义存储过程
SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE='PROCEDURE' AND GENERATED='N';

--查询存储过程参数
SELECT * FROM ALL_ARGUMENTS WHERE OBJECT_NAME='usp_Test'

--查询所有用户表
SELECT * FROM USER_TABLES ORDER BY TABLE_NAME

--查询所有表
SELECT * FROM ALL_TABLES ORDER BY TABLE_NAME

--查询表空间的用户表
SELECT * FROM USER_TABLES where TABLESPACE_NAME='MAIN';

--查询所有用户表的字段
SELECT * FROM USER_TAB_COLS;

--查询所有表的字段
SELECT * FROM ALL_TAB_COLS;

--查询所有用户表字段说明
SELECT * FROM USER_COL_COMMENTS

--查询所有用户表说明
SELECT * FROM USER_TAB_COMMENTS