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
- 16377 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 the difference among union, minus and intersect?
What is basic structure of pl sql?
What is pl sql block structure?
What is function and procedure in pl sql?
Is hadoop a nosql?
How do I upgrade sql?
Why commit is not used in triggers?
Why do we use procedures in sql?
Which are the different types of indexes in sql?
How do I make my sql query run faster?
Can you have more than one trigger on a table?
What is dml with example?
Can function return multiple values in sql?
What is parallel hint?
What is a trigger word?
