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
How to write a query with a left outer join in ms sql server?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
How do I partition a table in sql server?
What is sql injection and why is it a problem? : sql server security
Can a database be shrunk to 0 bytes, if not, why?
How is sql used in sql server?
Does partitioning improve performance?
How do I save a stored procedure in sql server?
Why main is user defined function?
What is the cartesian product of table?
What is the maximum row of a size?
Can we insert data into view sql server?
What command would you use to add a column to a table in sql server?
What is order of B+tree?
What are the different index configurations a table can have?