I was using table name to fetch the data. Now I have changed it to schemaname.table in the statement. It is working fine. But my doubt is why shoould we give schema name for sure? why is it not working with table name?
If I have to make changes to all my sql statement like select * from table to select * from cp.table , what should I do? or do we have any work around for this where all my sql statements consider schema name included by default?
harsharamoju
Member
4 Points
34 Posts
Re: SqlException Was Unhandeld By User Code??? (Invalid Object Name CP_ADS')
Mar 06, 2012 02:27 AM|LINK
I was using table name to fetch the data. Now I have changed it to schemaname.table in the statement. It is working fine. But my doubt is why shoould we give schema name for sure? why is it not working with table name?
If I have to make changes to all my sql statement like select * from table to select * from cp.table , what should I do? or do we have any work around for this where all my sql statements consider schema name included by default?