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

How to create percentile function?

139

---

What is the difference between a check constraint and a rule?

1130

---

What samples and sample databases are provided by microsoft?

975

---

What does it mean to be in union?

870

---

What are the steps you must follow to hide sql server instances?

929

---

How to return the top 5 rows from a select query in ms sql server?

1073

---

What is autocommit mode in sql server?

1078

---

What is the difference between rank and dense_rank?

990

---

how to do partition in sqlserver

2408

---

What stored by the msdb? : sql server database administration

952

---

Explain the working of sql privileges?

1038

---

What is a non clustered primary key?

873

---

Explain tables in SQL Azure?

120

---

Mention the differences between local and global temporary tables.

951

---

what is the main function of a query parameter?

140

---