select sobj.name, scol.name, stype.name, scol.length, scol.isnullable, scol.colstat from sysobjects sobj inner join syscolumns scol on sobj.id = scol.id inner join systypes stype on scol.xtype = stype.xtype where sobj.xtype = 'U' and scol.name = 'idcolonia' order by sobj.name, scol.colOrder