sys.schemas - Listing All Schemas in a Database in SQL Server

Q

How To List All Schemas in a Database in SQL Server?

✍: FYIcenter.com

A

If you want see all existing schemas in the current database, you can use view sys.schemas as shown in the example below:

USE FyiCenterData;
GO

SELECT * FROM sys.schemas;
GO
name                 schema_id   principal_id
-------------------- ----------- ------------
dbo                  1           1
guest                2           2
INFORMATION_SCHEMA   3           3
sys                  4           4
fyi                  5           1
db_owner             16384       16384
db_accessadmin       16385       16385
db_securityadmin     16386       16386
db_ddladmin          16387       16387
db_backupoperator    16389       16389
db_datareader        16390       16390
db_datawriter        16391       16391
db_denydatareader    16392       16392
db_denydatawriter    16393       16393
(14 row(s) affected)

All schemas, except "fyi", in the list were created by SQL Server.

 

Creating and Managing Schemas in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-22, 830👍, 0💬