A select s1.name tabela, s2.name coluna,s3.name tipo, s2.iscomputed, s2.isnullablefrom sysobjects s1, syscolumns s2, systypes s3where s1.xtype='T'and s1.xid=s2.xid and s2.xtype=s3.xtypeand s2.xusertype=s3.xusertypeorder by s1.name, s2.name
B select s1.name tabela, s2.name coluna,s3.name tipo, s2.iscomputed, s2.isnullablefrom systables s1, syscolumns s2, systypes s3where s1.xcode=s2.xcode and s2.xtype=s3.xtypeand s2.xusertype=s3.xusertypeorder by s1.name, s2.name
C select s1.name tabela, s2.name coluna,s3.name tipo, s3.iscomputed, s3.isnullablefrom systables s1, syscolumns s2, systypes s3where s1.tableid=s2.tableid and s2.xtype=s3.xtypeand s2.xusertype=s3.xusertypeorder by s1.name, s2.name
D select s1.name tabela, s2.name coluna,s3.name tipo, s2.iscomputed, s2.isnullablefrom sysobjects s1, syscolumns s2, systypes s3where s1.xtype='U'and s1.id=s2.id and s2.xtype=s3.xtypeand s2.xusertype=s3.xusertypeorder by s1.name, s2.name
E select s1.name tabela, s2.name coluna,s3.name tipo, s2.iscomputed, s2.isnullablefrom systables s1, syscolumns s2, sysobjects s3where s1.xid=s2.xid and s2.xtype=s3.xtypeand s2.xusertype=s3.xusertypeorder by s1.name, s2.name