Hi, I have created a table which contains several standard columns and one computed column. What I'm trying to do is create a view on top of the table (select *) which will allow other users to update / insert into the underlying table. However, I'm having difficulty as the view recognises the computed column as a column which also requires a value to be inputted. Beyond changing the initial select statement in the view creation step to an explicit column list (minus the computed column), is there a way around this? Thanks e.g. CREATE TABLE test_table ( c1 int NULL, c2 int NOT NULL, c3 as c1 + c2 ) go CREATE VIEW test_view AS SELECT * FROM test_table GO INSERT INTO test_table VALUES (2,2) -- (1 row(s) affected) GO INSERT INTO test_view VALUES (2,2) -- Server: Msg 213, Level 16, State 4, Line 1 -- Insert Error: Column name or number of supplied values does not match table definition.