Problem to locate one table

[Former Member]

Hi Guys !!

Im writing one TSQL to get some informations about the Business Partners / Blanket Agreement, and im facing one problem:

On my screen, when i put my mouse over the textbox, it shows me the table named OAT4V, but there is no table with this name.

Where is that table? This tables exists?

[Johan_H · Accepted solution]

Hi Daniel,

V may stand for View. Please check the views of your database.

Regards,

Johan

[Former Member · Accepted solution]

Hi Johan,

Thanks for help! Another question, how can i discover the name of that view?

[Johan_H · Accepted solution]

Hi Daniel,

Generally speaking you should be able to reference a view the same way as any table, so if OAT4V doesn't work, I guess all you can do is sift through all the views in MS SQL Server Management Studio until you find the correct one.

Regards,

Johan