查看当前数据库

mysql:

select database()

Oracle:

SELECT sys_context('USERENV', 'CURRENT_SCHEMA') FROM dual

SQL server:(先查看当前spid,再根据spid查看当前数据库名)

Select Name From SysDataBases Where DbId=(Select Dbid From SysProcesses Where Spid = @@spid)

 

posted @ 2021-10-28 14:56  一人暮らしda  阅读(228)  评论(0)    收藏  举报