Can you set default Schema for SQL 2008 Query

sql-server-2008, t-sql

Solution

The default schema for all sql server users is "dbo", You can alter the default schema for a user by using commands ALTER USER

ALTER USER UserName WITH DEFAULT_SCHEMA = application;

Problem

I have a schema called application. Is there a way that, rather than using the syntax ``` SELECT * FROM application.table ``` I can set the default schema so that I can just use ``` SELECT * FROM table ``` It would be the same idea as a using statement I suppose.

Original source