Database schema ?

Hi!

I need SQL Script that works on database from 2000 in any higher version and generates FULL database schema. By full I mean all tables, all columns , all references , primary keys, foreing keys, contraints, and so on, with column types and their names. When I've said generates I meant just to display a table with all this features and their names, types and but not SQL that I can use it to regenerate such schema only display information about this schema ( hope it's clear now ).

I've found such script but it works only on SQL Server 2005, is it sth like this written for 2000 ?

Jarod

Its better to use DMO/SMO instead of TSQL