we can directly ALTER OR DROP the column AND THEN COMMIT ON IT SO THAT IT

How to delete an attribute from the emp table

Question Posted / swetha

Answer Posted / swetha

we can directly ALTER OR DROP the column AND THEN COMMIT ON
IT SO THAT IT GETS MODIFIED

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the rdl file?

What are the different types of subquery?

608

Explain how does the report manager work in ssrs?

489

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

671

Explain about SQLOS?

575

How many types of schemas are there?

519

Explain how many types of relationship?

565

What is the sql case statement used for? Explain with an example?

527

Can you always create a cache of a report?

115

Do you know the policy based administration feature of sql server 2008?

567

What is acid properties?

578

Define self join in sql server joins?

510

what is memory-optimized nonclustered indexes

545

What is query optimization process?

510

What is key set driven?

528