0
If the dropped table is a base table for a view , then dbms like oracle invalidates these dependent views but does not drop them. But you cannot use these unless you re-create the table.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What is the different between a view and a create view?
View is a virtual table that do not have any data of its own but have data that is derived from another table called base table. Create view is the command used to create a view (virtual table).
How do you view all the tables created in the database?
View is a virtual table with no data , but can be operated like any other table. It is like a virtual table through which you can view data of another table, which is known as the base table. Syntax for creating a view- CREATE VIEW as SELECT statement ;
Why create view in database?
A View is similar to a Table and can be mistaken for a table by a novice application developer. CREATE VIEW VIEW_NAME AS SQL QUERY Here the SQL Query includes the Select query on a table that is to be displayed as a View. The view is a read only structure that only displays contents from a table and the user cannot insert or update or delete any data in the underlying table. Views are generally created to impose access restrictions to a specific subset of users whom you do not want to give full access but at the same time want them to view the data.
Create view in SQL?
create view vw_active_employee as select * from employee where status = 'Active' after creating the view, view can be used as a table to see active employee. e.g. select * from vw_active_employee Basically we save sql as a database object, so that we can use that in future as a virtual table.
What provides a convenient way to enter and view records in a database table?
Form
What are the commands of view?
View is a virtual table with no data, but can be operated like any other table. creating a view : create view employee as select * from emp where gross>10000; dropping a view: drop view employee
What is the means drop command?
The DROP table command of SQL lets you drop a table from database . The database requires you to empty a table before you eliminate from the database. But there is a condition for dropping a table ; it must be an empty table. syntax: 1st - delete from table-name; 2nd- drop table table-name;
What is drop command?
The "drop" command is typically used in programming or databases to remove a specific element or entity. For example, in SQL, you can use the "DROP TABLE" command to delete a table from a database. It is important to use this command carefully, as it permanently deletes the specified object.
What is Table View's population?
The population of Table View is 23,445.
Basic commands in oracle?
See the list of Commands in Oracle ANALYZE AUDIT CALL CREATE CLUSTER ALTER CLUSTER DROP CLUSTER COMMENT COMMIT CONNECT CONSTRAINT CREATE CONTEXT DROP CONTEXT CREATE CONTROLFILE CREATE DATABASE ALTER DATABASE DELETE DESCRIBE CREATE DIMENSION ALTER DIMENSION DROP DIMENSION CREATE DIRECTORY DROP DIRECTORY EXEC EXECUTE IMMEDIATE EXPLAIN PLAN CREATE FUNCTION ALTER FUNCTION DROP FUNCTION GRANT CREATE INDEX ALTER INDEX DROP INDEX CREATE INDEXTYPE DROP INDEXTYPE INSERT INTERSECT CREATE JAVA ALTER JAVA DROP JAVA CREATE LIBRARY DROP LIBRARY CREATE DATABASE LINK DROP DATABASE LINK LOCK TABLE CREATE MATERIALIZED VIEW ALTER MATERIALIZED VIEW DROP MATERIALIZED VIEW CREATE MATERIALIZED VIEW LOG ALTER MATERIALIZED VIEW LOG DROP MATERIALIZED VIEW LOG MINUS NOAUDIT CREATE OUTLINE ALTER OUTLINE DROP OUTLINE CREATE PACKAGE/BODY ALTER PACKAGE DROP PACKAGE CREATE PFILE CREATE PROCEDURE ALTER PROCEDURE DROP PROCEDURE CREATE PROFILE ALTER PROFILE DROP PROFILE RECOVER RENAME ALTER RESOURCE COST REVOKE RMAN CREATE ROLE SET ROLE ALTER ROLE DROP ROLE ROLLBACK CREATE ROLLBACK SEGMENT ALTER ROLLBACK SEGMENT DROP ROLLBACK SEGMENT SAVEPOINT CREATE SCHEMA SELECT CREATE SEQUENCE ALTER SEQUENCE DROP SEQUENCE ALTER SESSION SHUTDOWN SNAPSHOT CREATE SPFILE STARTUP ASSOCIATE STATISTICS DISASSOCIATE STATISTICS CREATE SYNONYM DROP SYNONYM ALTER SYSTEM CREATE TABLE ALTER TABLE DROP TABLE CREATE TABLESPACE ALTER TABLESPACE DROP TABLESPACE CREATE TEMPORARY TABLESPACE SET TRANSACTION CREATE TRIGGER ALTER TRIGGER DROP TRIGGER TRUNCATE UPDATE UNION CREATE USER ALTER USER DROP USER CREATE VIEW ALTER VIEW DROP VIEW WHERE
Which view is used to create a table or to modify the structure of the table?
Design view.
What is the different between a view and a create view?
View is a virtual table that do not have any data of its own but have data that is derived from another table called base table. Create view is the command used to create a view (virtual table).
What is a table called with attached extensions sliding out from under each end?
The table can be called a drop leaf table, or a butterfly table. The table can be called a drop leaf table, or a butterfly table.
How do you view all the tables created in the database?
View is a virtual table with no data , but can be operated like any other table. It is like a virtual table through which you can view data of another table, which is known as the base table. Syntax for creating a view- CREATE VIEW as SELECT statement ;
Describe drop table commands of sql with both the options cascade and restrict?
A table can have object dependencies. Indexes, views, programs. When you give a "drop table" command, it will not drop the table that has dependencies unless you include the "cascade" command in the statement. The database programming is written this way to make sure you know the table has dependent objects and makes you explicitly say you want to drop the table and all its dependencies. You should be very careful with this command. If you find you need to restore this table, you'd also have to recreate the view and index and recompile the programs attached. The best way to recover from this is if you have a tool that will put the create statement into a file, including all attached objects. That way, if you drop the table and need to recover, all you have to do is run the create command which will recreate in a minute versus a recovery that could take 30 minutes to hours dependent upon the availability of the data. After you run the create statement, make sure all objects are attached, test the view and make sure the programs are VALID.
What is the maximum seating capacity on a drop leaf table?
The maximum seating capacity on a drop leaf table is 14.
When was Table View High School created?
Table View High School was created in 1986.
