Getting MS SQL Table owner from vb
Posted on 2003-02-20
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.