System table

Database Base Data Sheets

Maybe it’s a question for you, where to store when tables and columns are stored

In the case of tables we can say that in the table

sys.tables

It is stored with an ID column that is commonly known as a single database

After the generic tables were created, the columns are in the table

sys.columns

The tables can be accessed using columns of a table

Now when the columns were made, it’s time to build relationships between the tables of tables between tables in the table

sys.foreign_key_columns

Is stored

By combining the above tables one can say which table is related to the tables

In the following, we will discuss the structure of the View and Procedure