Error Finding Identity Column

I'm using SQL 2005 Server Management Studio -

I go to the Northwind database - new query window and paste this code, I just found on this forum, to find the Identity column:
SELECT C.name AS Colname, UPPER(U.name) AS Coltype, C.status AS Cstatus,
  C.ColId, C.Id AS Cid, C.length, C.xprec, C.xscale
  FROM syscolumns C
  JOIN sys.tables O ON C.id = O.object_id
  JOIN systypes   U ON C.xusertype = U.xusertype 
  WHERE O.name =  'Fred' AND C.status = 128
  ORDER BY C.colid SELECT C.name AS Colname, UPPER(U.name) AS Coltype, C.status AS Cstatus,
  C.ColId, C.Id AS Cid, C.length, C.xprec, C.xscale
  FROM syscolumns C
  JOIN sys.tables O ON C.id = O.object_id
  JOIN systypes   U ON C.xusertype = U.xusertype 
  WHERE O.name =  'Products' AND C.status = 128
  ORDER BY C.colid

However, I get an error message saying:
Invalid object name 'sys.tables'.

What might I be missing here?