Computer Science - Database Systems - Discussion
Discussion Forum : Database Systems - Section 4 (Q.No. 11)
11.
In SQL, which command(s) is(are) used to change a table's storage characteristics?
Discussion:
1 comments Page 1 of 1.
Maunank Shah (MONTS) said:
1 decade ago
ALTER TABLE is used to change table structure. Various Possible structure are as Follow.
1 > To DROP Column.
ALTER TABLE <table_name> DROP COLUMN <column_name>.
2 > To ADD Column.
ALTER TABLE <table_name> ADD <column_name> datatype.
1 > To DROP Column.
ALTER TABLE <table_name> DROP COLUMN <column_name>.
2 > To ADD Column.
ALTER TABLE <table_name> ADD <column_name> datatype.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers