What is the difference between alias table and duplicate table

Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic. Enterprise Software. If you delete any column in the Original table automatically deleted in alias table. If you delete any column in the Original table ,Its not reflected in Duplicate table. Kurt Wolff Posted December 29, 0 Comments. Thanks a lot…. Showing results for. Search instead for. Did you mean:. All forum topics Previous Topic Next Topic.

Alias table creates duplicate columns. I have a Dataset with the following relation. Should I delete these columns from the Model? Labels: Labels: Need Help. Message 1 of 7. In response to parry2k. Message 7 of 7. Mark my post as a solution. Creating an alias creates a copy of the table in metadata that will be referenced in SQL with that alias name.

It will have its own ID, distinct from the parent table. The Duplicate Table Duplicate Tables on the other hand allow us to create the structure or template of a table, but at the database level you will find no physical structure.

When creating an opaque view where the structure is the same as a table in the physical layer then we duplicate the table. Using the Invoice example from above we can create a duplicate table in the physical layer. KPI Partners provides strategic guidance and technology systems for clients wishing to solve complex business challenges involving cloud applications and big data.

Learn more. KPI Partners, Inc. KPI Partners Blog.