Skip to Content
author's profile photo Former Member
0
Former Member

Derived Table name appearing different

Posted on Jun 29, 2016 at 08:36 AM 21 Views

Hi All,

I have created a derived table with the name DT_Books in dev instance

but when I check its script in query panel the derived table name is replaced by another name Table_4.

However in Prod instance I can see the same derived table with same definition and when i view the script in query panel the derived table name is displaying appropriately as " DT Books"

Can anybody assist on this

Thanks,

Chaithra M.R

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo AMIT KUMAR
    AMIT KUMAR
    Posted on Jun 29, 2016 at 08:48 AM
    3

    is there double quotes in the Derived table name? if yes remove double quotes from the name and try.

    universe is built via UDT or IDT?

    Add a comment
    10|10000 characters needed characters exceeded

    • AMIT KUMAR Former Member
      Jun 29, 2016 at 09:29 AM

      Delimit "No Table Only" will remove the double quotes from the table name.it mean you will not get the Table_1 which is table Alias.

      if your query is like

      Select

      Table_1.Object1

      Table_1.Object2

      from

      table name as Table_1

      it means double quotes are around columns & table name.in that case use delimit No (Tables and Columns) option to remove the alias.

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.