What is an information scheme?

Information scheme in a relational database is a separate table that documents information about the database itself. This basic information concerns many different aspects of relational databases; contains data on tables, rows, columns and records; and helps the designers of the databases to check this information. Although it is part of a relational database, the information diagram acts as a separate database, although the scheme does not generate as a separate database when it is located on the server. Although this scheme is the standard used by the database designers, it is commonly accessible by non -standard challenges. All information in this scheme is only for reading, so users cannot change or manipulate databases from the scheme. If database designers want to display metadata or database information, they can use an information scheme. This displays most of the information, such as the number of tables, record names, or column and rows names. While the scheme looks like a table, it is a look, which means that with itNo files are connected.

This scheme looks very different from other forms in the database. The information diagram because of how it holds and displays information, acts as a separate database when users view the scheme. At the same time, the restriction of modification means that it does not work as a traditional database. Unlike the traditional database, which can be generated when placed on the server, the information scheme is not generated on the server. This means that the information diagram can only be accessed by viewing from the database program, not from the server.

There are many database standards for security and stability and the information scheme is one of these standards. This means all relational databases, regardless of who bucks should contain this function. At the same time, non -standard commands are used to access the scheme that distinguishes it from most other database standards. For example pThe "Show" and "Description" romans are used to view the scheme depending on the database model, although they are not standard commands.

changes and adjustments are not allowed from the information scheme because it is set to read only. This means that users can only read data from the scheme; They cannot perform any functions on information. Regardless of the level of user authorization, whether they are administrators or even database designers, there is no way to change this since 2011.