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
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Explain the advantages of merge replication?
What is a coalesce function?
How to create indexed view?
How to modify existing triggers using "alter trigger"?
Explain different forms of normalization?
What are basics of policy management?
What is the latest version of microsoft sql server?
Explain about system stored procedure?
What is reportserver and reportservertempdb ?
How to list all field names in the result set using mssql_field_name()?
How many databases instances are there in sql server 2000?
Explain logical operators in sql server?
What is factless fact table? : sql server analysis services, ssas
Explain the properties of the relational tables?
