本文主要介紹查看sql腳本的方法有哪些(如何在sql數(shù)據(jù)庫中使用腳本文件)？，下面一起看看查看sql腳本的方法有哪些(如何在sql數(shù)據(jù)庫中使用腳本文件)？相關(guān)資訊。
1。查詢當前所有數(shù)據(jù)庫表的復制代碼如下: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和肺結(jié)核。minor _ id = 0 c. {} = ptb。major _ idobject _ id在c.column_id = 1中。序列表2。查詢當前表所有字段、數(shù)據(jù)和約束的代碼如下: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)。功能鍵)然后 其他 結(jié)束。b .，tab foreign name = empty(idx . fkname，n )，outnamecol = empty (idx.ns，n )從sys.columns c中聯(lián)接sy。s . objects o c = o object _ id } { } { object _ id o . type = u and o . is _ ms _ shipped = 0 }內(nèi)部連接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內(nèi)部聯(lián)接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數(shù)據(jù)庫中使用腳本文件)？相關(guān)內(nèi)容請關(guān)注本站點。