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, 1756🔥, 0💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...