How to delete an attribute from the emp table

Question Posted / arun

4 Answers
9525 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to delete an attribute from the emp table..

Using the DROP COMMAND-
See the eg below--

create table stup(roll int,name varchar,marks int)
insert into stup values(1,'A',10)
insert into stup values(2,'B',20)
select * from stup
Alter table stup drop column marks
select * from stup

Is This Answer Correct ?

9 Yes

2 No

How to delete an attribute from the emp table..

Answer / 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

How to delete an attribute from the emp table..

Answer / amit srivastava

create table stup(roll int,name varchar,marks int)
select * from stup
Alter table stup drop column marks
select * from stup

Is This Answer Correct ?

1 Yes

0 No

How to delete an attribute from the emp table..

Answer / ram murthy

we can delete an attribute through delete command.

Is This Answer Correct ?

1 Yes

8 No

Post New Answer

More SQL Server Interview Questions

what is dbcc? : Sql server database administration

0 Answers

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

0 Answers

How to generate random numbers with the rand() function in ms sql server?

0 Answers

What is dml command?

0 Answers

What is sql view?

0 Answers

What are the underflow and overflow behaviors on float literals?

0 Answers

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers

Explain different types of index?

0 Answers

define and explain the differences between clustered and non-clustered indexes.

0 Answers Microsoft,

how to get the salary in descending order with out using the keyword desc in sql

5 Answers Ramco,

can any one say how to update the following senario I have a table <srabank> in which the table structure is as follows ANAME ACCNO LOCATION ACCTYPE BAL SBanuPrakash 31518746291 Punganur deposit 4000 Sreenivas 31518746292 mahoobnagar current 14000 Ranjith 31518746293 Karimnagar Savings 2000 Giresh 31518746294 Chennai deposit 40000 Boo 31518746295 Chennai Savings 20000 Jay 31518746296 Valachari Savings 1000 tirumalraj 31518746297 Vellore Savings 8000 The senario is We need to select one account number and check the balance after checking the balance if the balance exist we need to transfer to another account . in the from account the amount need to be reduced and in the to account the amount needed to be added. for example for the <accountno> <31518746291> the balance is <4000> for the <accno> <31518746292> the balance is <14000> after transferring the balance the details will look as follows <accno><31518746291> <bal> <2000> <accno><31518746292> <bal> <16000> the above mentioned two statment will come under the final result.

3 Answers

How can we write or define DDL statements in Sql server and DML statements?

3 Answers

For more SQL Server Interview Questions Click Here