what command is used to create a table by copying the
structure of another table including constraints ?
- 6 Answers
- 15178 Views
- CMC, eicc, I also Faced
- E-Mail Answers
Answer Posted / ben
crete view (view_name) as
select * from (table);
In SQL, a view is a virtual table based on the result-set of an SQL statement.
A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.
i think this is the right answer
:)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is file based approach?
What is the use of function in sql?
What is cursor and why it is required?
What is a relationship and what are they?
What do you mean by table in sql?
How do you create a unique index?
What is not in sql?
What are reports usually used for?
What are the uses of merge?
Is sql better than access?
Do ddl statements need commit?
What is the difference between the conventional and direct path loads? : aql loader
What is record type in pl sql?
What is dialect in sql?
how does a local variable is defined using t-sql? : Transact sql
