摘要：
2.1取得数据库中所有表名样例数据：语句：select t.name '表名' from sysobjects t where OBJECTPROPERTY(t.id,N'IsUserTable') = 1或者用select name from sysobjects where type='U'执行结果：2.2 取得所有表中的所有字段名语句：select distinct c.name '字段名' from sysobjectst, syscolumns cwhere t.id = c.idand OBJECTPROPERTY(t 阅读全文
