How to delete an attribute from the emp table
Answers were Sorted based on User's Feedback
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 |
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 |
we can delete an attribute through delete command.
Is This Answer Correct ? | 1 Yes | 8 No |
Explain Geography datatype in SQL Server
what is Full Text Search ?
What is exporting and importing utility?
What are the ways available in sql server to execute sql statements?
Explain a differential backup?
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?
what are the new features introduced in sql server 2000? : Sql server database administration
What is ms sql server service broker?
Can we call a function that has out parameter in select statement
Do you know spatial data types - geometry and geography in sql server 2008?
Why do we backup Active Directory ?
Explain how to maintain a fill factor in existing indexes?