CODEWITHSUNDEEP
t-sqlsql-server-2008
Fermin
Fermin

Reputation: 36081

Can you set default Schema for SQL 2008 Query

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.

Upvotes: 4

Views: 11001

Answers (2)

HuBeZa
HuBeZa

Reputation: 4761

It will be great to have a use statement for schemas. You can vote the feature suggestion on Microsoft connect.

Upvotes: 3

Wael Dalloul
Wael Dalloul

Reputation: 22994

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;

Upvotes: 9

Related Questions