adspace


Can we edit a view in sql?

Answer Posted / Shobhit Kumar Gupta

Yes, you can modify a view in SQL by using the CREATE OR REPLACE VIEW statement. This statement allows you to change the definition of an existing view. However, keep in mind that you cannot directly modify data through a view; instead, you must update the underlying table.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is sql server agent? : Sql dba

1189


What is the best sql course?

1064


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2102


what are all the common sql function? : Sql dba

1141


What is your daily office routine?

2353


What is the current version of sql?

1106


what are the advantages of sql ? : Sql dba

1154


Can we use distinct and group by together?

1147


define sql insert statement ? : Sql dba

1110


Is inner join faster than left join?

1287


what is dbms? : Sql dba

1070


how to escape special characters in sql statements? : Sql dba

1124


how to use regular expression in pattern match conditions? : Sql dba

1125


how to start mysql server? : Sql dba

1279


What is the current version of postgresql?

1188