Table ID and Table Name

Comments

• Options

  infonote Member Posts: 233

  2011-04-11

  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.

  Blog: http://www.kaizenlog.com

  0
• Options

  117320 Member Posts: 33

  2011-04-11

  Thank you infonote.
  
  the exact querry is SELECT * FROM "Object", I get from client monitor.

  0