Untuk memanggil semua schema yang ada di dalam suatu database kita dapat menggunakan query berikut:
SELECT
s.name AS [schema_name],
u.name AS [schema_owner]
FROM
sys.schemas s
INNER JOIN sys.sysusers u ON u.uid = s.principal_id
ORDER BY
s.name
s.name AS [schema_name],
u.name AS [schema_owner]
FROM
sys.schemas s
INNER JOIN sys.sysusers u ON u.uid = s.principal_id
ORDER BY
s.name
Hasilnya kira-kira seperti ini:
0 Comments