From: reb01501@NOSPAMyahoo.com   
      
   Still not enough specific information. How do you intend that the primary   
   and foreign keys be stored in the file? As a separate resultset? Show us   
   what you want to see in the file given a 3-colomn table with three rows, a   
   primary key on the first column and a foreign key on the third.  Exactly   
   what will the file contain. Will it be a text file? If so, show us the text.   
      
   Tony Johansson wrote:   
   > I want to get the name of the columns, the primary key and foreign   
   > key and the contents.   
   > I want all this output to be stored in a file.   
   > I can do select * but can I redirect the output to a file.   
   >   
   > //Tony   
   >   
   > "Erland Sommarskog"  skrev i meddelandet   
   > news:XnsA092F33A6DD1CYazorman@127.0.0.1...   
   >> Tony Johansson (johansson.andersson@telia.com) writes:   
   >>> I need to extract a sql dump from several tables where I can see the   
   >>> contens and primary key and foreign key   
   >>   
   >> SELECT *? Or do you want the "dump" in any special format? Can you   
   >> be more specific?   
   >>   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)