本文主要介绍查看sql脚本的方法有哪些(如何在sql数据库中使用脚本文件)？，下面一起看看查看sql脚本的方法有哪些(如何在sql数据库中使用脚本文件)？相关资讯。
1。查询当前所有数据库表的复制代码如下:select o.object_id as id，o.name tablename =，table desc = o . type joins sys . objects o c = o object _ id } { } from inside sys . columns c . { object _ id o . type = u and o . is _ ms _ shipped = 0 internal connection sys . types t in c . user _ type _ id = t . user _ type _ id left connection sys . extended _ properties ptb for lung tuberculosis .class = 1和肺结核。minor _ id = 0 c. {} = ptb。major _ idobject _ id在c.column_id = 1中。序列表2。查询当前表所有字段、数据和约束的代码如下:select but，o.name，columnline = c.column_id，columnname = c.name，typenum = t.name，typelength = c.max_length，fstate = empty (g.value，n )，isablenull = = 1，c.is_nullable然后n else n 终端b .，defaultdata = empty (d.definition，n )，当isidentity = = 1时，c.is_identity然后n else n 当is =(选择1，pk and parent _ objxtype = = c { object _ id } and name)(从indidsyindexes(从sysindexkeys id中选择indid是c . { } and object _ id gives = c . column _ id)中选择名字的地方) 其他 ends b .，它是外交=存在于案例中(选择sysforeignkeys fk，c {object_id} = fk.fkeyid和c.column_id = fk)。功能键)然后 其他 结束。b .，tab foreign name = empty(idx . fkname，n )，outnamecol = empty (idx.ns，n )从sys.columns c中联接sy。s . objects o c = o object _ id } { } { object _ id o . type = u and o . is _ ms _ shipped = 0 }内部连接sys . types in c . user _ type _ id = t . user _ type _ id左连接sys . extended _ properties g in c object _ id } = { g . major _ id and c . column _ id = g . minor _ id左连接sys . default _ constraints d in c object _ id } = { d . parent _ object _ id and c . column _ id = d . parent _ column _ id and = {fk.fkeyid和c.column _ id = fk.fk——索引和键信息(select idx.fkeyid，idx.fkey，fkname = o.name，ns = ss.name从idx的sysforeignkeys idx内部联接sys.objecto。 rkeyid = o object _ id } { o . type = u and o . is _ ms _ shipped = 0左连接列的ss在rkeeyid = ss.ididx .和rkey = ss.colid idx中。idx)在c object_id} = {idx.fkeyid和c.column_id = idx.fkey在o.name = n {0}中，表名为查询o.name，c.column_id iii。添加单引号varchar、char、nchar、nvarchar、text、ntext、date和time而不添加int、numbers和bits而不添加长度:{2}、{character}、{decimal}、{nchar}、{number}、{nvarchar}、{ } { } varbinary varchar:{ dot } { bigint }、{in}、{、} floating、image、{in {} {} xml、timestamp field}、{、{uniqueidentifier}、{money}、{ntext}、{room}，{smalldatetime}、{smallint}、{smallmoney}、{sql_variant}、{text}
了解更多查看sql脚本的方法有哪些(如何在sql数据库中使用脚本文件)？相关内容请关注本站点。