The MSSQLConnection class is accessible via the sqlobject.mssql.mssqlconnection module.
"\n SELECT col.name, col.status, obj.name\n FROM syscolumns col\n JOIN sysobjects obj\n ON obj.id = col.id\n WHERE obj.name = '%s'\n and col.autoval is not null\n\n "
"\n select\n name,\n length,\n ( select name\n from systypes\n where cast(xusertype as int)= cast(sc.xtype as int)\n ) datatype,\n prec,\n scale,\n isnullable,\n cdefault,\n m.text default_text,\n isnull(len(autoval),0) is_identity\n from syscolumns sc\n LEFT OUTER JOIN syscomments m on sc.cdefault = m.id\n AND m.colid = 1\n where\n sc.id in (select id\n from sysobjects\n where name = '%s')\n order by\n colorder"
Here we take raw values coming out of syscolumns and map to SQLObject class types.
See the source for more information.