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
- 16227 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
How many types of relationship are there?
Define commit?
What is meant by <> in sql?
Does sql between include endpoints?
Enlist the characteristics of pl/sql?
can a stored procedure call itself or recursive stored procedure? : Sql dba
What are the different set operators available in sql?
What is sql rowcount?
what are the features and advantages of object-oriented programming? : Sql dba
what are enums used for in mysql? : Sql dba
How many sql statements are used? Define them.
What is dense_rank in sql?
What is sorting in sql?
What is pl sql and why it is used for?
What are transaction and its controls?
