Table ID and Table Name

117320117320 Member Posts: 33
edited 2011-04-11 in SQL General
Hi all,

In the Object Designer we can see Table ID and Table Name information,Where is this information store in the sql or how to retrieve the information from SQL?

Thank You.

Comments

  • infonoteinfonote Member Posts: 233
    To see the table name, you will need to login to SQL Server Management Studio if you use SQL option.
    An alternative is to use client monitor. You will be able to view the SQL Queries.
    117320 wrote:
    Hi all,

    In the Object Designer we can see Table ID and Table Name information,Where is this information store in the sql or how to retrieve the information from SQL?

    Thank You.
  • 117320117320 Member Posts: 33
    Thank you infonote.

    the exact querry is SELECT * FROM "Object", I get from client monitor.
Sign In or Register to comment.