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

USE GlobalGuideLineDatabase;

GO

SELECT * FROM sys.schemas;

GO

name    schema_id principal_id

-------------------- ----------- ------------

dbo   1   1

guest   2   2

INFORMATION_SCHEMA 3   3

sys   4   4

ggl   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 "ggl", in the list were created by SQL Server.