How to create a view on a table which does not exists

Answer Posted / vijayakumar

Using FORCE Command we can create a view without base table.

Is This Answer Correct ?    40 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we insert delete data in view?

559


how tsql statements can be written and submitted to the database engine? : Transact sql

542


Is sql difficult?

757


Can we have two clustered index on a table?

574


What is a recursive stored procedure?

625






how many values can the set function of mysql take? : Sql dba

541


what are the advantages and disadvantages of cascading style sheets? : Sql dba

569


What are types of indexes in sql?

548


What are the benefits of triggers?

619


What is sql not null constraint?

617


What is the command used to fetch the first 5 characters of a string?

717


what are the performance and scalability characteristics of mysql? : Sql dba

542


Does asenumerable execute the query?

609


Why use truncate instead of delete?

553


How do we accept inputs from user during runtime?

561