Collections:
Default Schema of Your Login Session in SQL Server
What Is the Default Schema of Your Login Session in SQL Server?
✍: FYIcenter.com
When you login to a SQL Server and select a database to use, SQL Server will assign your login session a default schema. The schema name can be omitted when you refer to objects in the default schema. Here is what you should remember about default schema:
The tutorial exercise below shows you how to verify your default schema:
-- Login with "fyi_login" USE FyiCenterData; GO Changed database context to 'FyiCenterData'. PRINT User_Name(); GO Fyi_User SELECT name, default_schema_name FROM sys.database_principals WHERE type = 'S'; GO name default_schema_name -------------------- -------------------- dbo dbo guest guest INFORMATION_SCHEMA NULL sys NULL Fyi_User dbo
The last query shows that the default schema for "fyi_login" in "FyiCenterData" is "dbo".
⇒ Who Is the Owner of a Schema in SQL Server
⇐ "sys.objects" - Listing All Objects in a Given Schema in SQL Server
2016-10-22, 1540🔥, 0💬
Popular Posts:
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...