Hi Peter,
I can understand that it is important to maintain naming pattern same as system catalogs, but in that case we may need to redefine system catalogs naming conventions .
So that we can use those newly added naming conventions in system views as well.
It is difficult to understand usename = database user name and usesysid = system user id.
It is better to use full names to those columns, so that Users can easily understand those columns by their names.
In this case adding one or more laters will not cause any problem but will add more readability.
In case adding 3 letters indicating the catalog , can we use 4 or 5 letters ?
I think we need to rethink about these short naming conventions which are making confusion, If community is ok with that.
Please share yours thoughts on this.
Regards,
Sachin Kotwal