Research of Information Extraction from SQL Server Based on SQL-DMO

被引：0

作者：

Zheng, Wei ^{[1
]}

Wu, Yaping ^{[2
]}

Chen, Yaofei ^{[3
]}

机构：

[1] Zhejiang Radio & Tv Univ, Hangzhou 310030, Zhejiang, Peoples R China

[2] Shaoxing Univ, Shaoxing, Peoples R China

[3] Jinhua Polytechn, Jinhua 321007, Peoples R China

来源：

AUTOMATION EQUIPMENT AND SYSTEMS, PTS 1-4 | 2012年 / 468-471卷

关键词：

Information Extraction; SQL-DMO; SQL Server; Skill Assessment;

D O I：

10.4028/www.scientific.net/AMR.468-471.278

中图分类号：

TP [自动化技术、计算机技术];

学科分类号：

0812 ;

摘要：

This article describes the SQL Server object model SQL-DMO. Through the object model all information of SQL Server's internal objects can be obtained, including databases, data tables, stored procedures and triggers and so on. Analysis the method of the object's information extraction. Get the child object by analyzing the parent object's collection property and get internal information by analyzing the object's properties. A visual basic procedure is designed to achieve the table's structure information for all user tables in specified SQL Server database. This method is more complete and simple than the method based on system table.

引用

页码：2878 / +

页数：2