1 get all columnname
select?[name]?from?syscolums?where?id=object_id('tablename)
2 get all tables
select [name] from SysObjects where type='U'
3 get all datatype of system
select?[xtype],[name] from SysTypes?

轉載于:https://www.cnblogs.com/Winston/archive/2008/01/16/1040970.html

總結

以上是生活随笔為你收集整理的get all table's information concerned的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。