>There should be a system table to restore this information, but i forget its name,could anybody give me a clue? Tks in adv.

SELECT * FROM pubs.INFORMATION_SCHEMA.Columns