Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1178

Re: How do I best take a sql dump with contents where you can see pk and fk

Show all headers | View raw

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" <esquel@sommarskog.se> 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?
>>

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

How do I best take a sql dump with contents where you can see pk and fk "Tony Johansson" <johansson.andersson@telia.com> - 2012-07-16 13:59 +0200
  Re: How do I best take a sql dump with contents where you can see pk and fk Erland Sommarskog <esquel@sommarskog.se> - 2012-07-16 23:54 +0200
    Re: How do I best take a sql dump with contents where you can see pk and fk "Tony Johansson" <johansson.andersson@telia.com> - 2012-07-17 00:01 +0200
      Re: How do I best take a sql dump with contents where you can see pk and fk Erland Sommarskog <esquel@sommarskog.se> - 2012-07-17 00:07 +0200
      Re: How do I best take a sql dump with contents where you can see pk and fk "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-07-16 19:35 -0400
  Re: How do I best take a sql dump with contents where you can see pk and fk rja.carnegie@gmail.com - 2012-07-17 06:14 -0700

csiph-web