what command is used to create a table by copying the
structure of another table?
- 7 Answers
- 13669 Views
- I also Faced
- E-Mail Answers
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
What is a primary index?
Which are the new data types introduced in sql server 2008?
What to perform pattern match with the like operator?
How can you tell if a database object is invalid?
when would you go for denormalization? : Sql server database administration
How to convert numeric values to integers in ms sql server?
What are a scheduled jobs or what is a scheduled tasks?
How to delete a database in ms sql server?
What is sub query and its properties?
What are the 7 disadvantages to a manual system?
Is port 1433 secure?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Can a unique index be created on a column, which contains null?
Explain where clause?
Explain DBCC?
