摘要:
查询表和字段: SELECT CASE WHEN COL.COLID = 0 THEN tab.Table_name ELSE '' END 表名, --main.COLUMN_NAME 主键名, col.colid 顺序号, case when main.COLUMN_NAME = col.nam 阅读全文
摘要:
我的达梦数据库为 WEBLAS_TYTY 1.达梦查询视图个数: SELECT COUNT(*) AS view_count FROM ALL_VIEWS WHERE OWNER = 'USERNAME'; sqlserver: SELECT COUNT(*) AS view_count FROM 阅读全文