Clever Geek Handbook

What is a good name for a configuration value that contains this table or view name?

Is there a database term for "table or view"?
In my application, the name of the table I am fetching data from is configured using a config setting UserTableName

Now the DBA went in and renamed the table but created the view using the original name.
So nothing has changed on my side, but now I feel like it UserTableName

is misleading and I would like to change it to UserWhateverName wherever the term for a table or view is.
Is there such a thing or am I just an idiot?

0


source to share


5 answers


Logical models use the terms entity / attribute; Physical models use table / column. I don't know if the designer would mind, but perhaps you can call it "UserEntity".



Here's the question: why is it important? When you write a query in SQL, you don't know or care if it's a table or a view. Why do you need your circuit?

+1


source


The term "relation" refers to a table or view. In fact, the relation also refers to the query result.



+2


source


How about a "database object" or "DBObject"?

+1


source


how about " UserDataSource

"?

0


source


I would stick with what you have. What the folks at Oracle have done for their data dictionary (name names sometimes appear in a column called table_name).

0


source






More articles:


All Articles