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

获取SQLServer元数据的几种方法（Several ways to obtain SQLServer metadata） Metadata profile The definition of metadata (metadata) is the most common data structure relevant data, or the simple point is information about the data, in the daily life of the legend, the library catalog card and name card etc can be regarded as metadata. In relational database management systems (DBMS), metadata describes the structure and meaning of data. For example, when managing, maintaining SQL, Server, or developing database applications, we often get information about the schema of the database: The number and name of tables and views in a database; The number of columns in a table or view, and the name, data type, length, precision, description, etc of each column; Constraints defined on a table; The index defined on a table and the information of the primary key / foreign key. Here are some ways to get metadata. Acquiring Metadata Accessing metadata using system stored procedures and system functions The most common way to obtain metadata is to use the system, stored procedures, and system functions provided by SQL Server. System stored procedures and system functions provide an abstraction layer between system tables and metadata, enabling us to obtain metadata of the current database object without directly querying the system tables. Commonly used metadata related system stored procedures are listed below: System stored procedure description Sp_columns returns detailed information about the column of the specified table or view. Sp_databases returns the basic information for all databases on the current server. If the sp_fkeys parameter tables with primary keys, the return contains all the tables of the table point; if the parameters for the table name with foreign keys, returns all the same primary key / foreign key relationships associated with the combination of all foreign key table. Sp_pkeys returns the primary key information for the specified table. Sp_server_info returns the vari