2
What is a static table in SQL Server? I can’t understand this concept by internet searches.
1 answer
2
In fact it is only a concept and as far as I know there is nothing in SQL Server or other database that defines this clearly as a mechanism (in Mysql only using Myisam there is the term for something else entirely different). A static table is one that should not be changed, it is practically read-only. This is not to say that it can never be changed, but this is rare and is not done by normal operations available to users. But I stress that all this is only conceptual, nothing prevents to do different.
Examples of type tables are cities and states, specific codes of something that serve as a description for something. Often these tables are called descriptive, reference or lookup. They are usually very simple, and have no more than an identifier and a description. They can be compared to enumerations that some banks or languages have, but are not so fixed.
Browser other questions tagged sql-server modeling ssms
You are not signed in. Login or sign up in order to post.
Can you show the text in which you found this "concept"? You need to understand the context to answer in a specific way.
– José Diz
Did the answer solve your question? Do you think you can accept it? See [tour] if you don’t know how you do it. This would help a lot to indicate that the solution was useful for you. You can also vote on any question or answer you find useful on the entire site (when you have 15 points, so accept the answer).
– Maniero