VRGultom
asked on
Getting MS SQL Table owner from vb
Hi All,
I have database created when instalation. The database name and table owner create automatically as user entered.
I need to know the table owner using query so, I can use it for another query, because whenever I run the sql statement I always have to determine the table owner name. Example the sql statement like this:
select * from parameter
It is error, because the table parameter is not recognized. I have to write:
select * from user1.parameter.
User1 is the table owner. Whereas the table owner is not always user1.
Please Help.
Thanks
Veronika
I have database created when instalation. The database name and table owner create automatically as user entered.
I need to know the table owner using query so, I can use it for another query, because whenever I run the sql statement I always have to determine the table owner name. Example the sql statement like this:
select * from parameter
It is error, because the table parameter is not recognized. I have to write:
select * from user1.parameter.
User1 is the table owner. Whereas the table owner is not always user1.
Please Help.
Thanks
Veronika
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
VRGultom:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
ASKER