查询Sqlserver的全部的模式名称

Query below lists all schemas in SQL Server database. Schemas include default db_* , sys, information_schema and guest schemas.

If you want to list user only schemas use this script.

Query

select s.name as schema_name, 
s.schema_id,
u.name as schema_owner
from sys.schemas s
inner join sys.sysusers u
on u.uid = s.principal_id
order by s.name

 
 

  
  Code has been copied
 
 

Columns

• schema_name - schema name
• schema_id - schema id, unique within the database
• schema_owner - principal that owns this schema

Rows

• One row represents one schema in a database
• Scope of rows: all schemas in a database, including default ones
• Ordered by schema name

Sample results

Here is a view of database schemas in SSMS:

---

《算法导论 第三版英文版》_高清中文版

《深度学习入门：基于Python的理论与实现》_高清中文版

《深入浅出数据分析》_高清中文版

《Python编程：从入门到实践》_高清中文版

《Python科学计算》_高清中文版

《深度学习入门：基于Python的理论与实现》_高清中文版

《深入浅出数据分析》_高清中文版

《Python编程：从入门到实践》_高清中文版

---

--查新SqlServer中的全部模式
SELECT 1
FROM   (SELECT TOP(100) s.name   AS schema_name
                        , s.schema_id
                        , u.name AS schema_owner
        FROM   sys.schemas s
               INNER JOIN sys.sysusers u ON u.uid = s.principal_id
        ORDER  BY s.name) T1
WHERE  UPPER(T1.schema_name) = 'SSDBSP_001_000_000';