+ 1

With nicknames does it have to be two letters or can you extend it with an extra letter or so as it may get more confusing or does it make it easier?

14th Dec 2016, 6:16 AM
Rebecca Wolf
Rebecca Wolf  - avatar
2 Respuestas
0
It depends how your are changing the table names with your own nicknames.... there is no confusion at all
15th Dec 2016, 8:28 AM
Mukesh Reddy Kongari
Mukesh Reddy Kongari - avatar
0
A nickname is kind of mnemonic helper. Whether it is one character or a longer string the nicknames shall make sense. Normally, I use 2 to 5 characters for table aliases, an example: select ordr.ID as ORDR_ID, itm.NAME as ORDR_ITEM, ... from ORDERS_T ordr join ORDER_ITEMS_T itm on ordr.ID = itm.ORDER_ID ;
20th Dec 2016, 8:17 PM
Stephan Borsodi
Stephan Borsodi - avatar