Interested to Buy Any Domain ? << Click Here >> for more details...
write down the code for "how we delete a table without
using of Drop command " ?
- 7 Answers
- 11447 Views
- CarrizalSoft Technologies, Sonata, I also Faced
- E-Mail Answers
Answer Posted / bhagwat sharma
table delete only by
drop table (tablename)
if you want do delete all data from table than you wil use
command
truncate table (tablename)
this command don't delete table delete only table data ok
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Explain different types of self contained sub query?
Explain error handling in ssis?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
How to insert stored procedure result into temporary table?
Mention what are the core components of ssrs?
Can you tell me some of the common replication dmv's and their use? : sql server replication
Tell me about normalization in DBMS.
Where are sql server user names and passwords stored in sql server?
Can we use where clause in union?
What are the basic functions for master, msdb, model, tempdb databases?
Can we do dml on views?
Where actually sql azure database is hosted?
What is the meaning of resultset type_scroll_insensitive?
What is the syntax to execute the sys.dm_db_missing_index_details?
