執(zhí)行sql

select  o.name,cl.name,cm.text from sysobjects o,syscolumns cl, syscomments cm
 where o.id = cl.id and cl.cdefault = cm.id  and o.type='U'
  and o.name='test2' and cl.name like 'col%'

test2是標(biāo)明, col%是列名通配符, 'U' 表示表格是用戶(hù)表

返回結(jié)果:

name                           name                           text                                                                                                                                                                                                                                                           
----                           ----                           ----                                                                                                                                                                                                                                                           
test2                          col1                           DEFAULT (0)                                                                                                                                                                                                                                                    
test2                          col2                           DEFAULT  2                                                                                                                                                                                                                                                     
test2                          col3                           DEFAULT  getdate()            

syscolumns 中 id 表示對(duì)應(yīng)的表格在sysobjects中id, cdefault表示在syscomments中的缺省值注釋id

缺省值可能會(huì)出現(xiàn)函數(shù), 例如  default getdate(),

所以我覺(jué)得應(yīng)該這個(gè)缺省值可以剝離掉default, 如果使用hibernate實(shí)現(xiàn),還只能用dynamic insert,dynamic update.