SQL – set default schema for each D/B

[Mr. Mangus]

In SQL Server Manager Studio (SSMS) you can set a default schema on per D/B, per user basis.
If you want to shorten your SQL statements, you can remove explicit D/B name by using USE command

USE Your_DB_Name

Furthermore, you can remove explicit SCHEMA name by setting default SCHEMA for each database (Security – Logins – Your User Name – User Mapping).

Now you can refer to tables with a simple table name, like Your_Table_Name instead of a long notation Your_DB_Name.SCHEMA.Your_Table_Name.

[Author]

Posts