I heard the term "static table" when I'am learning about dirty reads in database.

Can anyone explain what is a "static table" and what is a "dynamic table"? Thanks in advance.

| improve this question | | | | |

Static tables are the master tables that are populated with some canned data at the time of creation of the database in a typical system setup. Rather they have a pre defined set of data populated in them that hardly changes. There is no specific term like Static table and Dynamic table, but all tables that are used for inserts, updates and deletes with data getting modified can be termed as dynamic tables

Source: https://www.sqlservercentral.com/forums/topic/static-and-dynamic-table#post-663097

| improve this answer | | | | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.