Collections:
sys.schemas - Listing All Schemas in a Database in SQL Server
How To List All Schemas in a Database in SQL Server?
✍: FYIcenter.com
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 a New Table in a Given Schema in SQL Server
⇐ "CREATE SCHEMA" - Creating a New Schema in a Database in SQL Server
2016-10-22, 2248🔥, 0💬
Popular Posts:
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...