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, 2345🔥, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...