If I insert a record into a SQL table, do I need to open the entire SQL table, or can I have a small view and then insert a record that would not fit in that view.

I meanif I vae a view for phone number =123 and then I insert a new record n SQL for phone number 456. Do I need to open entire SQL database, or can I insert from that smaller view????

THANKS
Joel
Houston, TX