达梦数据库常用命令

发布时间 2024-01-09 09:42:41作者: 笨笨和呆呆

https://blog.csdn.net/qq_44819536/article/details/124235560

 

SELECT DISTINCT object_name FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'SCH'     ##模式这里就是指database,查看所有database

 

根据模式名查询表名

SELECT table_name FROM dba_tables WHERE owner = '模式名'

SELECT table_name FROM dba_tables WHERE owner = 'SOLAR_FORECAST';

DESCRIBE solar_forecast.actual_load;

delete from solar_forecast.suntime where mode=0;