Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
antony_dba
Starting Member
26 Posts |
Posted - 2010-12-02 : 07:23:25
|
please suggest the solution for sql query without using schemakris |
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-02 : 07:30:47
|
you can't, unless the schema of the objects in the query is your default schema (usually dbo).-- With Qualified Schema SELECT * FROM schemaName.TableName-- Without Specifying Schema-- (only works if object belongs to your default schema)SELECT * FROM TableName |
|
|
antony_dba
Starting Member
26 Posts |
Posted - 2010-12-02 : 07:41:15
|
thanks i got itkris |
|
|
|
|
|