當前位置:成語大全網 - 新華字典 - 請問sql中的數據字典是什麽,起到什麽作用?

請問sql中的數據字典是什麽,起到什麽作用?

就是維護整個數據庫運行的內部表。屬於數據庫系統的表。

oracle官方的解釋是

One of the most important parts of an Oracle database is its data dictionary, which is a read-only set of tables that provides information about the database. A data dictionary contains:

The definitions of all schema objects in the database (tables, views, indexes, clusters, synonyms, sequences, procedures, functions, packages, triggers, and so on)

How much space has been allocated for, and is currently used by, the schema objects

Default values for columns

Integrity constraint information

The names of Oracle users

Privileges and roles each user has been granted

Auditing information, such as who has accessed or updated various schema objects

Other general database information

The data dictionary is structured in tables and views, just like other database data. All the data dictionary tables and views for a given database are stored in that database's SYSTEM tablespace.