达梦数据库sql

我的达梦数据库为

WEBLAS_TYTY

1.达梦查询视图个数：

SELECT COUNT(*) AS view_count
FROM ALL_VIEWS
WHERE OWNER = 'USERNAME';

sqlserver:

SELECT COUNT(*) AS view_count
FROM INFORMATION_SCHEMA.VIEWS;

 

2.达梦查询存储过程个数：

SELECT COUNT(*) AS procedure_count
FROM ALL_PROCEDURES
WHERE OWNER = 'WEBLAS_TYTY';

sqlserver:

SELECT COUNT(*) AS procedure_count
FROM sys.procedures;

 拼接表：

 SELECT 'select * from '|| TABLE_NAME||';' FROM USER_TABLES;