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.

1 Answer 1


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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