I already have a table EMP_DETAILS, which is containing (EMP_ID (Primary Key), FIRST_NAME, LAST_NAME, AGE, ADDRESS, SALARY, DEPT_ID (Foreign Key),
DELETE_DATE).
I already created a View for the table, but when I created that table I missed one column (FIRST_NAME).
I want to add that column in this existing View with out drop this.