-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07/15/2011 06:19 PM, san long wrote: > Is there any good solution to satisfy my requirement?
Since you want absolutely nothing to see them, delete them. Or make triggers to copy data between the real table that contains all the data and your surrogate table that is missing this data. Or alter the queries in the applications. Or make a view. Or make a virtual table. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk4hC4AACgkQmOOfHg372QS5NwCgy/r8zkTpjeuvNtqv9Vy0hmqL o8sAnje+hWHuWx+/uARNLATY5Gpc3yK2 =+veo -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users