write down the code for "how we delete a table without
using of Drop command " ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sachin tendulkar
Can not be deleted without using DROP key word.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / krishna
without using drop command u cant delete table .truncate is
only for delete the data parminently with out commit.where
as delete only for records deleting with commit
statement.once u commit for delete stmt it cant rollback.
Is This Answer Correct ? | 4 Yes | 1 No |
plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
How to select top 5 coloumn from a table without using coloumn name
What are magic tables in sql server?
How to return the date part only from a sql server datetime datatype?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What are the type of joins? When do we use Outer and Self joins?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
what is the system function to get current user's user id? : Sql server database administration
How to see the event list of an existing trigger using sys.trigger_events?
Can the “if update (colname)” statement be used in a delete trigger?
What is a database in ms sql server?