sys.tables join sys.columns in SQL 2000

How would you convert the above in SQL 2000?
sys.tables AS tab
INNER JOIN
sys.columns col
ON
tab.OBJECT_ID = col.OBJECT_ID
LVL 6
anushahannaAsked:
Who is Participating?
 
chapmandewCommented:
select * from sysobjects o
join syscolumns c on o.id = c.id
0
 
anushahannaAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.