what command is used to create a table by copying the
structure of another table?
Answer Posted / kunal sain
create table table_name
as select * from another_table
where 1>2;
| Is This Answer Correct ? | 7 Yes | 9 No |
Post New Answer View All Answers
Define full outer join in sql server joins?
What is the fillfactor concept in indexes?
How to perform backup for certificates in sql server? : sql server security
Why transaction is important?
What is cte (common table expression)?
Can select statements be used on views in ms sql server?
How to use the inserted and deleted pseudo tables?
What is difference between equi join and inner join?
What is cached report?
what data regions are and what are the different data regions?
What is 2nf normalization?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Explain the collation?
When you should use a low fill factor?
What is sql view?