获取SQLServer元数据的几种方法（Several ways to get SQL server metadata）.docVIP

获取SQLServer元数据的几种方法（Several ways to get SQL server metadata） Metadata introduction Metadata (metadata) one of the most common is defined as data about data structure, or a little bit more simple is information about data, the legend of daily life, the library catalog card and card, etc. Can be regarded as metadata. In a relational database management system (DBMS), metadata describes the structure and meaning of the data. For example, when managing, maintaining SQL Server, or developing database applications, we often get information about the database schema: The number and name of tables and views in a database; The number of columns in a table or view, as well as the name, data type, length, precision, description, etc. Of each column; Constraints defined on a table; Information defined on a table and the primary key/foreign key. Below we introduce several ways to get metadata. Fetch metadata Use system stored procedures and system functions to access metadata The most common way to get metadata is to use the system stored procedures and system functions provided by SQL Server. The system stored procedures and system functions provide an abstraction layer between system tables and metadata, allowing us to obtain metadata for the current database object without having to query the system tables directly. Common metadata related system stored procedures have the following: System stored procedure description Sp_columns returns the details of the columns of the specified table or view. Sp_databases returns the basic information for all databases on the current server. Sp_fkeys, if the parameter is a table with a primary key, returns all tables containing foreign keys that point to the table; If the parameter is a table name with foreign key, all tables associated with the foreign key are returned. Sp_pkeys returns the primary key information for the specified table. Sp_server_info returns the various properties of the current server and their corresponding values. S