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, 1535🔥, 0💬
Popular Posts:
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...