how can I get metadata in SQL Server 2k?

  • Thread starter Thread starter nghia ngo dinh
  • Start date Start date
N

nghia ngo dinh

Hi all,
I'm working on the project, using asp.net with sql server 2k.
I have to read all the information in database, included TableName,
FieldName, Views, Store Procedures, User Definined functions, ....
How can I get them? If someone know about it, please help me!
Thanks.
nghiangodinh.
-----------------------------
Nghia Ngo Dinh
Software Developer
(e-mail address removed)
Mob: 0903.800.622
Tel: (08) 997.1572
 
Hi,

Take a look at t-sql's information_schema.referential_constraints and
information_schema.key_column_usage and other objects beneath
information_schema.

HTH,

Bernie Yaeger
 
Back
Top