Re: [sqlite] ATTACH DATABASE .tables .schema ?

[Amit Chaudhuri]

I'm a huge fan of the command line tool. At work we use it extensively when
prototyping.  We're probably amongst the less technically sophisticated of
users, so the ability to quickly script an approach using a few text files
is something we value hugely. It's a great way of weaning people off
spreadsheets in situations where data volumes stretch their capabilities.
But I sometimes wonder if it could be an even bigger plus with a little more
attention.  This seems to me like a worthy area for enhancement if it is
technically "easy."

If we had strong C skills I'd be inclined to have a go. [But I can say that
in full safety!]


On Mon, Jun 13, 2011 at 4:09 PM, Jay A. Kreibich  wrote:

> On Sun, Jun 12, 2011 at 05:29:32PM -0400, ap scratched on the wall:
> > When I attach additional DB's with ATTACH DATABASE how can I view the
> schema
> > or tables in the (non main) databases?
> >
> >
> >
> > ATTACH DATABASE 'C:\temp\test.db' AS T
> >
> > .schema  T
> >
> > .tables T
> >
> > Produce no results.
>
>   You can't.  The CLI dot-commands only show results for the
>  "main" and "temp" databases.
>
>   -j
>
>
> --
> Jay A. Kreibich < J A Y  @  K R E I B I.C H >
>
> "Intelligence is like underwear: it is important that you have it,
>  but showing it to the wrong people has the tendency to make them
>  feel uncomfortable." -- Angela Johnson
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ATTACH DATABASE .tables .schema ?

[Jay A. Kreibich]

On Sun, Jun 12, 2011 at 05:29:32PM -0400, ap scratched on the wall:
> When I attach additional DB's with ATTACH DATABASE how can I view the schema
> or tables in the (non main) databases?
> 
>  
> 
> ATTACH DATABASE 'C:\temp\test.db' AS T
> 
> .schema  T
> 
> .tables T
> 
> Produce no results.

  You can't.  The CLI dot-commands only show results for the 
  "main" and "temp" databases.

   -j


-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] ATTACH DATABASE .tables .schema ?

[ap]

When I attach additional DB's with ATTACH DATABASE how can I view the schema
or tables in the (non main) databases?

 

ATTACH DATABASE 'C:\temp\test.db' AS T

.schema  T

.tables T

 

Produce no results.

 

Thanks.

 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users