<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
selectcasewhenc.colid=1thenobject_name(c.id)else''endas表名
,c.nameas字段名
,t.name
数据类型
,c.precas
长度
,p.valueas描述信息
,m.textas默认值
fromsyscolumnsc
innerjoinsystypestonc.xusertype=t.xusertype
leftjoinsyspropertiesponc.id=p.idandc.colid=p.smallid
leftjoinsyscommentsmonc.cdefault=m.id
whereobjectproperty(c.id,'IsUserTable')=1
虽然很简单，但发表出来，希望能帮助初学的朋友，只要细心研究syscolumns,systypes...等系统表，就可以得到你所想要的信息！
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>