what command is used to create a table by copying the
structure of another table including constraints ?
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
Name the operator which is used in the query for pattern matching?
What is group function in sql?
How is data stored on a disk?
What is cte sql?
Which are the different types of indexes in sql?
What is the primary use of normalization?
How do you modify a column in sql?
describe mysql connection using mysql binary. : Sql dba
Is it possible to include an insert statement on the same table to which the trigger is assigned?
How to rename a column in the output of sql query?
What are the 3 types of behavioral triggers?
Is pl sql still used?
Explain character-manipulation functions?
Can we use rowid as primary key?
how can we find the number of rows in a table using mysql? : Sql dba