what command is used to create a table by copying the
structure of another table?
Answers were Sorted based on User's Feedback
Answer / hokar
SELECT * INTO tabname1 FROM tabname2 WHERE 1=2 (TO copy
only the structure)
Is This Answer Correct ? | 18 Yes | 4 No |
Answer / naik
select * into oldtable from newtable where oldtable
=newtable
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kunal sain
create table table_name
as select * from another_table
where 1>2;
Is This Answer Correct ? | 7 Yes | 9 No |
Answer / narsing
SELECT * INTO tabname1 FROM tabname2 WHERE 1<>2 (TO copy
only the structure)
Is This Answer Correct ? | 0 Yes | 3 No |
Give a example to search fr a string in all stored procedure in sql server.
How to receive returning result from a query?
What are the disadvantages of using querystrings to send data from one page to another?
What are the types of dml?
What is named calculation? : sql server analysis services, ssas
Which table keeps the locking information?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
How many types of functions are there in sql server?
Can we add an identity column to decimal datatype?
how many non clustered index in sql server 2008,2010,2012
what is differencial backup?how to work?Anybody explai it?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration