Re: How can I have table and column definitions?

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