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=@.TableName... 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
Now don't go off and 'reinvent the wheel'.
Try these articles:
http://www.theserverside.net/tt/articles/showarticle.tss?id=DataSetDesigner
http://www.codegeneration.net/tiki-index.php?page=NET
http://www.codegeneration.net/generators.php
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"ThunderMusic" <NoSpAmdanlatathotmaildotcom@.NoSpAm.com> wrote in message
news:u6BSHIYFHHA.1240@.TK2MSFTNGP03.phx.gbl...
> 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=@.TableName... 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
>
|||because I want to add my own things in it... and because we will probably
generate 100's of classes, I don't want to cut and paste my things in all
these classes... with my code generator, I'll be sure the classes reflect
exactly what we really need.
thanks tought, those links may be helpful...
ThunderMusic
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:OtThwNYFHHA.5000@.TK2MSFTNGP03.phx.gbl...
> Now don't go off and 'reinvent the wheel'.
> Try these articles:
> http://www.theserverside.net/tt/articles/showarticle.tss?id=DataSetDesigner
> http://www.codegeneration.net/tiki-index.php?page=NET
> http://www.codegeneration.net/generators.php
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "ThunderMusic" <NoSpAmdanlatathotmaildotcom@.NoSpAm.com> wrote in message
> news:u6BSHIYFHHA.1240@.TK2MSFTNGP03.phx.gbl...
>
|||I thought the links might give you ideas, if not even code...
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"ThunderMusic" <NoSpAmdanlatathotmaildotcom@.NoSpAm.com> wrote in message
news:u2BNr6YFHHA.1784@.TK2MSFTNGP06.phx.gbl...
> because I want to add my own things in it... and because we will probably
> generate 100's of classes, I don't want to cut and paste my things in all
> these classes... with my code generator, I'll be sure the classes reflect
> exactly what we really need.
> thanks tought, those links may be helpful...
> ThunderMusic
>
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:OtThwNYFHHA.5000@.TK2MSFTNGP03.phx.gbl...
>