取得Ms SqlServer数据库中某张表的所有列:
SELECT sysobjects.name AS TABLENAME, syscolumns.NAME as NAME, systypes.name VTYPE, syscolumns.LENGTH, syscolumns.XPREC, syscolumns.XSCALE, isnullable, cdefault FROM syscolumns,sysobjects,systypes WHERE syscolumns.id = sysobjects.id and syscolumns.xtype = systypes.xtype and sysobjects.type='U' and sysobjects.name = 表名
取得Oracle数据库某张表的所有列:
SELECT TNAME AS TABLENAME, CNAME AS NAME, COLTYPE AS V......
阅读全文