CREATE TABLE table_203_594 (id NUMBER, "canal" CLOB, "length  ( miles ) " NUMBER, "locks" NUMBER, "max length  ( ft ) " NUMBER, "width  ( ft ) " NUMBER, "year opened" NUMBER, "year abandoned" NUMBER, "year restored" NUMBER)

the year forth and clyde was restored
SELECT "year restored" FROM table_203_594 WHERE "canal" = 'forth and clyde canal'
SELECT "year restored" FROM "table_203_594" WHERE "canal" = 'forth and clyde canal'