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
- 16635 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 scope of pl sql developer in future?
What are character functions?
what is try_catch block in procedure
Which is better varchar or nvarchar?
Is sql dba a good career? : SQL DBA
What is record data type?
How many subqueries can be nested in a statement?
What are the different dml commands in sql?
Can a select statement fire a trigger?
what is the stuff function and how does it differ from the replace function? : Sql dba
What is the difference between having clause and where clause?
How to add, remove, modify users using sql?
What are the two types of exceptions.
What is right join in sql?
what are the advantages of sql ? : Sql dba
