On Sep 3, 2011, at 8:21 PM, Walter wrote:

> 
> On 9/2/2011 11:02 PM, Walter wrote:
> 
>> >  Is there any way to get the user_version from an Attached database
>>   
> PRAGMA attachedName.user_version;
> 
> -- Igor Tandetnik Thank you Igor I had the database name but did not think of 
> the the dot in between. Perhaps some one could update the documentation to 
> show this Cheers everyone Walter
> 


it is a pretty common SQL convention, using periods to separate the 
database_from.schema_from.table_from.column

You don't have to specify the left-side qualifier if the entity on the right of 
the period can be located unambiguously.

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

Reply via email to