Duplicate column names in same or different table

[Manikandan2]

Hi, 

what happens if i use the same column name(not column label) in 2 tables? Will it cause any issue? If Yes, what type of issue will be caused.

Thanks,

Manikandan

[Chalan B L]

No you have to do everything manually from creating table to creating fields. Mark answer as correct and helpful if it helped you.. Regards, Chalan

[Tejal Zete]

Hi Manikandan,

You can have same column name in 2 different tables but in child table it is not allowed to create field with same name as in parent table If we try to create it then it give a message column already exists in table or extended from it.

If you want to duplicate a table with all the column names then extends the table into another table which you want to duplicate.

Mark Correct/Helpful, if this helps you.

Thanks and regards,

Tejal

[Inactive_Us2002]

There is no Issue with the use of "same column name" in two different tables. But it is not possible when the table is inherited.

[Pat Surtan]

Hi,

Piggy backing off this topic here. The incident table already has a field called category but my users don't want the INC prefix and prefer to have their own prefix for ticket numbering. Because of this, I am thinking about creating a new table and add another category field for this table. Is it okay to have a field called category in 2 separate tables? Is there a way to reuse that category field from the incident table while still having my new prefix for ticket numbers to go along with the inc prefix for incidents?