Interested to Buy Any Domain ? << Click Here >> for more details...
what command is used to create a table by copying the
structure of another table including constraints ?
- 6 Answers
- 16183 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
Can I call a procedure inside a function?
List out the acid properties and explain?
What is the difference between row level and statement level trigger?
Is sqlite good enough for production?
What are different categories of sql commands?
what is foreign key? : Sql dba
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is a loop in sql?
which operator is used in query for pattern matching? : Sql dba
What is sql character function?
What are keys in sql?
Can we join 3 tables in sql?
What is denormalization in a database?
does sql support programming? : Sql dba
What view means?
