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
- 16422 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 sql databases can you have on one server?
What does the argument [or replace] do?
how to rename an existing table in mysql? : Sql dba
What is the use of function in sql?
How many indexes can be created on a table in sql?
How do I restart sql?
What are all ddl commands?
What is an emotional trigger?
How to display the records between two range in Oracle SQL Plus?
What does 0 mean in sql?
What are the different tcl commands in sql?
What is data abstraction in sql?
Why do we use joins?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
what is acid property in database? : Sql dba
