[SqlServer] 获取 数据库 sqlserver 关键字

最近在做个在线创建数据库表的工具，所以要用到数据库的原本的关键字，用于比对，所创建的表的列名是否为数据库的关键字。

但是数据库的关键字，从哪来？

访问 sqlserver的关键字说明官网

保留关键字

发现他把关键字都存在dom元素中的,一个个粘贴比对，得累死人,而且我们是程序员啊，怎么能用这么粗暴的方法那.

1.打开控制台

2.执行以下脚本

var res=[];
$('.tableSection table').each(function(){
    var $table = $(this);
    $table.find('tr').each(function(){
        var $tr = $(this);
        $tr.find('td p').each(function(){
            res.push($(this).text());
        })
    });
});

3.将res序列化下，就可以拿到所有的

JSON.stringify(res)

总共688个关键字

["ADD","EXISTS","PRECISION","ALL","EXIT","PRIMARY","ALTER","EXTERNAL","PRINT","AND","FETCH","PROC","ANY","FILE","PROCEDURE","AS","FILLFACTOR","PUBLIC","ASC","FOR","RAISERROR","AUTHORIZATION","FOREIGN","READ","BACKUP","FREETEXT","READTEXT","BEGIN","FREETEXTTABLE","RECONFIGURE","BETWEEN","FROM","REFERENCES","BREAK","FULL","REPLICATION","BROWSE","FUNCTION","RESTORE","BULK","GOTO","RESTRICT","BY","GRANT","RETURN","CASCADE","GROUP","REVERT","CASE","HAVING","REVOKE","CHECK","HOLDLOCK","RIGHT","CHECKPOINT","IDENTITY","ROLLBACK","CLOSE","IDENTITY_INSERT","ROWCOUNT","CLUSTERED","IDENTITYCOL","ROWGUIDCOL","COALESCE","IF","RULE","COLLATE","IN","SAVE","COLUMN","INDEX","SCHEMA","COMMIT","INNER","SECURITYAUDIT","COMPUTE","INSERT","SELECT","CONSTRAINT","INTERSECT","SESSION_USER","CONTAINS","INTO","SET","CONTAINSTABLE","IS","SETUSER","CONTINUE","JOIN","SHUTDOWN","CONVERT","KEY","SOME","CREATE","KILL