摘要：Access里查看所有表:sql=”select * from MSysObjects where type=1 and flags=0″MsysObjects是系统表，在一般情况下是隐藏着。可以通过设置来显示出来：工具>选项>视图>(选中)系统对象 阅读全文

摘要：select name from syscolumns where id = object_id('user')select a.name as [column],b.name as typefrom syscolumns a,systypes bwhere a.id=object_id('user') and a.xtype=b.xtype and a.name='userid'表清单conn.... 阅读全文