113
Views
2
Comments
Get Actual Database Name
Question

Is there a sql query or something that I can get the actual sql name? that I can use to print to the screen?

like

[OUTSYSTEMS].DBO.[OSUSR_XXX_INFORMATION]
Rank: #500

David Chen wrote:

Is there a sql query or something that I can get the actual sql name? that I can use to print to the screen?

like

[OUTSYSTEMS].DBO.[OSUSR_XXX_INFORMATION]

David,

I guess SQL Map on Forge can help you out.


Best regards


Rank: #41498

Hi David,

The actual table information is available in Entity. Manage dependencies>System Entities> Espace,Espace_Entity and Entity. Run an aggregate with the joins of the above three entities and pass your table name in Entity>Name.

Regards