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 |
how can you check the level of fragmentation on a table? : Sql server administration
Explain the use of keyword with encryption. Create a store procedure with encryption?
can we call stored Procedure in Function in Sql Server 2000 and vice versa.
3 Answers C3I, eSoft, iPRO Solutions, Wipro,
how to determine the service pack currently installed on sql server? : Sql server database administration
What is the difference between system objects and user objects?
Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?
What are number line correlation administrators will use while working with a subquery?
What are the advantages of using a stored procedure?
What is auditing in sql server?
What is temporal data type?
How do I find the transaction log size in sql server?
What is scd (slowly changing dimension)? : sql server analysis services, ssas