access不知道,SQLSERVER中:
1、select name from sysobjects where type='u'得到所有用户表。
2、select Name from syscolumns where id=object_id('tablename')
1、select name from sysobjects where type='u'得到所有用户表。
2、select Name from syscolumns where id=object_id('tablename')
比如用ADO的原生