database sql extraction

[cyclopsvs]

Hello all,

I recently started working on a project where one of the first steps is to extract the complete sql querie from which the database is designed.

I was wondering is there is a simple method to do this so i can see al the primary keys and foreign keys ?

thanks in advance for your help

richard mendes

 

[r937]

depends on which database you're using -- DESCRIBE tablename, SHOW CREATE TABLE tablename, etc.

or, you could use the INFORMATION_SCHEMA views



r937.com | rudy.ca