Re: How can I have table and column definitions?

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@xxxxxxxxxx> wrote in message
news:u2BNr6YFHHA.1784@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxx> wrote in message
news:OtThwNYFHHA.5000@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxx> wrote in message
news:u6BSHIYFHHA.1240@xxxxxxxxxxxxxxxxxxxxxxx
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







.

Relevant Pages

  • Re: Domain or Workgroup
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ... installed, since better security is now available, file storage may be ...
    (microsoft.public.sqlserver.clients)
  • Re: Domain or Workgroup
    ... comments which contradict others' suggestions or material in a ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ...
    (microsoft.public.sqlserver.clients)
  • Re: Domain or Workgroup
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ... installed, since better security is now available, file storage may be ...
    (microsoft.public.sqlserver.clients)
  • Re: Domain or Workgroup
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... to connect to a server and not being properly configured. ... installed, since better security is now available, file storage may be ...
    (microsoft.public.sqlserver.clients)
  • Re: Linked Server Security question
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... that folder and all files in it. ... it's related somehow to the security on that linked server. ...
    (microsoft.public.sqlserver.connect)
Loading