[Tech] SQL Server 스키마 조회

OS : Microsofr Windows Server 2019 Datacenter

DB : Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 Express Edition (64-bit)

 

SQL Server는테이블 생성시 default로 dbo 스키마로 생성된다.

[1] 스키마 조회

1> select * from sys.schemas;
2> go
name                                                                  schema_id   principal_id
--------------------------------------------------------------------- ----------- ------------
dbo                                                                             1            1
guest                                                                           2            2
INFORMATION_SCHEMA                                                              3            3
sys                                                                             4            4
entr                                                                            5            1
acc                                                                             6            1
moris                                                                           7            1
cert                                                                            8            1
elec                                                                            9            1
mille                                                                          10            1
dlib                                                                           11            1
developer                                                                      12            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

(21개 행 적용됨)
1>