Suppose I have to create a view on a table, that is not yet been
created by DBA. I khow the table structure. Is it possible to
create the view before DBA creates this table? If yes then how?
Is it possible to create synonym in this way?
Answer Posted / neo
Synonym can be created on non-existing table without using
Force keyword. It automatically become valid once table is
created.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what are the types of join and explain each? : Sql dba
Can we join more than 2 tables in sql?
What is the purpose of a secondary key?
Explain select statements in sql?
Explain the difference between 'between' & 'and' operators in sql
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
Can you have more than one trigger on a table?
what are the security recommendations while using mysql? : Sql dba
What is a temporal table?
Is stored procedure faster than query?
What is a primary key called that is made up of more than one field?
What is sql*loader?
What is insert command in sql?
What is the use of sqlerrd 3?
what is a trigger in mysql? Define different types of trigger. : Sql dba