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

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

Path	csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail
From	"Bob Barrows" <reb01501@NOSPAMyahoo.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: How do I best take a sql dump with contents where you can see pk and fk
Date	Mon, 16 Jul 2012 19:35:23 -0400
Organization	A noiseless patient Spider
Lines	25
Message-ID	<ju28ff$hrs$1@dont-email.me> (permalink)
References	<ju0vmv$d1h$1@dont-email.me> <XnsA092F33A6DD1CYazorman@127.0.0.1> <ju2317$i4m$1@dont-email.me>
Injection-Date	Mon, 16 Jul 2012 23:35:12 +0000 (UTC)
Injection-Info	mx04.eternal-september.org; posting-host="bd099084a2caba1d0ebe690afacb9523"; logging-data="18300"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/N5fJGEFpjdDpOHtMbU/dgVPgsviVhmrA="
X-MimeOLE	Produced By Microsoft MimeOLE V6.00.2900.6157
X-RFC2646	Format=Flowed; Response
X-Antivirus-Status	Clean
X-Newsreader	Microsoft Outlook Express 6.00.2900.5931
X-Antivirus	avast! (VPS 120302-0, 03/02/2012), Outbound message
Cancel-Lock	sha1:7U3NpCWCzZxeHD/nqJt4Rh4Y0vo=
X-Priority	3
X-MSMail-Priority	Normal
Xref	csiph.com comp.databases.ms-sqlserver:1178

Show key headers only | 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