我的名字:“周末” 程序猿/轻设计/轻生活/轻日记/轻梦想 === 微信:zhoumojianshe ===
© 优特良品&优特建站出品 | Powered by YOUTIY
苏ICP备13018047号-1
SqlServer查询表字段的默认值
TAGS: 后端设计
	SELECT SO.NAME AS "Table Name", SC.NAME AS "Column Name", SM.TEXT AS "Default Value"
	FROM dbo.sysobjects SO INNER JOIN dbo.syscolumns SC ON SO.id = SC.id
	LEFT JOIN dbo.syscomments SM ON SC.cdefault = SM.id
	WHERE SO.xtype = 'U' and so.name='tbArticle'
	ORDER BY SO.[name], SC.colid

执行结果:


本文由周末简设原创出品,如需转载请注明出处
本文出处:http://www.youtiy.com/detail_607.html

周末
2021-11-23 10:47:11
标签云
网页设计 精致慢生活 感悟思语 我的旧年华
加偶微信