最近在做个在线创建数据库表的工具,所以要用到数据库的原本的关键字,用于比对,所创建的表的列名是否为数据库的关键字。
但是数据库的关键字,从哪来?
访问 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