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
Explain the microsoft sql server delete command? : SQL Server Architecture
What is temporary table in sql server? Why we use temp table?
What is a partition key?
How to filter records of table in SQL SERVER?
what is the primary use of the model database? : Sql server administration
How can you set the threshold at which sql server will generate keysets asynchronously?
How important do you consider cursors or while loops for a transactional database?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How many types of triggers are there?
What are the aggregate and scalar functions?
Explain error and transaction handling in sql server?
What is delete query?
What is scheduled job and how to create it?
Where the sql logs gets stored? : sql server database administration
What is difference between foreign key and unique key?
