How can I have table and column definitions?

Hi,
I want to develop a code generator for our Data-Access Layer and I'd like to
know if there are queries I can make to have the table and column
definitions... something like Select * From Tables and Select * From
Columns Where TableName=@xxxxxxxxxxxxx something like this... I know there
are views in SqlServer 2005... for the Table Definition, I think it's
INFORMATION_TABLES or something like it... there is a similar table for
columns, but some properties are missing, like if the columns is an
Identity...

I also want to know if there is a way to retrieve the relationships like
Table1.Field1-->Table2.Field2 or something like this...

If you have a link to a web site I can find all those informations, go ahead
and post it... ;) but for those who would be tempted, don't post
www.google.com, I already tried to find something useful without any real
success...

Can someone help me please?

Thanks

ThunderMusic


.

Loading