How can I create a table from another table without copying any values from the old table?
Answer Posted / arun
Select top 0
into newtable
from oldtable
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is the difference between set and select?
How to generate create view script on an existing view?
What is a group function explain with an example?
How do I install only the client tools of sql server 2000?
What protocol does sql server use?
How to name query output columns in ms sql server?
How do I edit a stored procedure in sql server?
You want to implement the one-to-many relationship while designing tables. How would you do it?
What is difference between cte and view?
How we can compare two database data?
What is Service Broker in sql server 2012?
Which are new data types introduced in sql server 2008?
What is the fastest way to permanently delete a 1 million row table named customers?
Give main differences between "Truncate" and "Delete".
What is the new security features added in sql server 2016? : sql server security