Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sonia
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 |
Post New Answer View All Answers
What is conditional split?
What are “lock” hints?
What is a matrix in ssrs?
How to bind a view to the schema of the underlying tables?
Name few endpoints exposed by ssrs 2012?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is self contained scalar sub query?
Define inner join? Explain with an example?
What are relationships and mention different types of relationships in the dbms
Explain triggers?
Explain rdbms?
How to find the list of fixed hard drive and free space on server?
How to get the query of a table in sql server?
Can you create a logon trigger in sql server 2005 express edition?
What is Lock table in SQL?
