SQLSERVER如何获取一个数据库中的所有表的名称一个表中所有字段的名称.docVIP

如何获取一个数据库中的所有表的名称、一个表中所有字段的名称？ ?? 1、如何用SQL获取一个数据库中的所有表的名称; 2、如何用SQL获取一个表中所有字段的名称; ！ good2speed(Goodspeed) 于 2005-5-19 11:56:43 ?? 1、如何用SQL获取一个数据库中的所有表的名称; SELECT * FROM sysobjects WHERE xtype=u ?? 2、如何用SQL获取一个表中所有字段的名称; SELECT c.name,o.name FROM syscolumns AS c INNER JOIN sysobjects AS o ON c.id = o.id pbsql(风云) 于 2005-5-19 11:56:59 ?? select name from sysobjects where xtype=U select name from syscolumns where id=object_id(N表明) paoluo(一天到晚游泳的鱼) 于 2005-5-19 11:59:42 ?? ?? Select Name from sysobjects where Type=U Select Name from syscolumns where ID=OBJECT_ID(NTableName) Order By ColID mengzulin(Julian) 于 2005-5-19 12:02:14 ?? SELECT dbo.sysobjects.name AS [table], dbo.syscolumns.name AS columns FROM dbo.sysobjects INNER JOIN dbo.syscolumns ON dbo.sysobjects.id = dbo.syscolumns.id WHERE (dbo.sysobjects.xtype = u) dazhu2(边城浪子【倚天不出，谁与争锋】) 于 2005-5-19 12:12:11 ?? 学习 huangdun(惇惇) 于 2005-5-19 12:18:27 ?? select name from sysobjects where xtype=U select name from syscolumns where id=object_id(Nname) good2speed(Goodspeed) 于 2005-5-19 12:20:35 ?? 1、如何用SQL获取一个数据库中的所有表的名称; SELECT * FROM sysobjects WHERE xtype=u ?? 2、如何用SQL获取一个表中所有字段的名称; SELECT c.name,o.name FROM syscolumns AS c INNER JOIN sysobjects AS o ON c.id = o.id xluzhong(Ralph) 于 2005-5-19 12:48:03 ?? --查询表结构信息 --邹老大的 SELECT? 表名=case when a.colorder=1 then d.name else end, 表说明=case when a.colorder=1 then isnull(f.value,) else end, 字段序号=a.colorder, 字段名=a.name, 标识=case when COLUMNPROPERTY( a.id,a.name,IsIdentity)=1 then √else end, 主键=case when exists(SELECT 1 FROM sysobjects where xtype=PK and parent_obj=a.id and name in ( SELECT name FROM sysindexes WHERE indid in( SELECT indid FROM sysindexkeys WHERE id = a.id AND colid=a.colid ))) then √ else end, 类型=b.name, 占用字节数=a.length, 长度=COLUMNPROPERTY(a.id,a.name,PRECISION), 小数位数=isnull(COLUMNPROPERTY(a.id,a.name,Scale),0), 允许空=case when a.isnullable=1 then √else end, 默认值=isnull(e.text,), 字段说明=isnull(g.[value],) FROM syscolumn