On 26-02-2012 06:58, 黃楨民 wrote: > Dear all: > I run sqlite3 In windows shell command environment and make a > connection to database in thw way like 『>sqlite3 dbone.sq3』. > Then, attach database 'dbtwo.sq3' as dbtwo. How could I get schema of detwo > under windows shell command ? > Please help! > Best Regards > tom
select "main", m.* from main.sqlite_master m where type='table' union all select "dbtwo", m.* from dbtwo.sqlite_master m where type='table'; _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
