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