-----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

Reply via email to