Yak Posting Veteran
Constraint Violating Yak Guru
Very Important crosS Applying yaK Herder
quote:Originally posted by xrumi have some tables in a car schema.i changed my user's default schema to carbut when i try to do the following:select * from toyotai still get the following:Msg 208, Level 16, State 1, Line 2 Invalid object name 'toyota'.i have to specify car before it works like so:select * from car.toyotai already did this:ALTER USER mex WITH NAME = mex;ALTER USER mex WITH DEFAULT_SCHEMA = car;is there something else i'm missing? how can i keep the car schema but still be able to query it with just the table name?