如何查找SQL Server用户数据库名称 [英] How to find SQL Server User Database Names

问题描述

如何使用查询获取用户定义的数据库名称......

注意：

1.我不想显示系统数据库等作为master，tempdb .....

select * from sys.databases join？

result

显示每个数据库名称及其owner_sid 。

2.对于sys数据库，owner_sid保持不变。我不想使用owner_sid Where 子句。

3.要获取该owner_sid NAME，我应该将哪个表加入上述查询。

How to get the user defined databases name using query......
note:
1. I don''t want to show system databases such as master,tempdb.....
select * from sys.databases join ?
result
It showing every database names and its owner_sid.
2. For sys databases owner_sid remains same. I don''t want to use owner_sid Where clause.
3. To get that owner_sid NAME to which table should I join that above query.

推荐答案

查询返回用户数据库及其所有者的姓名：

Query returns user databases and their owner''s name:

select D.name, P.name 
from  sys.databases AS D
inner join sys.server_principals As P
on D.owner_sid=P.sid 
where d.database_id>4 

查询返回所有数据库及其所有者的姓名：

Query returns all databases and their owner''s name:

select D.name, P.name 
from  sys.databases AS D
inner join sys.server_principals As P
on D.owner_sid=P.sid 

这篇关于如何查找SQL Server用户数据库名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！