Computer Science - Database Systems - Discussion
Discussion Forum : Database Systems - Section 2 (Q.No. 12)
12.
Which command(s) is(are) used to redefine a column of the table in SQL ?
Discussion:
1 comments Page 1 of 1.
Maunank Shah (MONTS) said:
1 decade ago
ALTER TABLE is used to change Table Structure.
To Re Define Column Name :
ALTER TABLE <Table_Name> ALTER COLUMN <Column_Name> <DataType>.
Here, Just type New DataType That you want to Change.
Warning: Data May be lost if un-compatible size.
To Re Define Column Name :
ALTER TABLE <Table_Name> ALTER COLUMN <Column_Name> <DataType>.
Here, Just type New DataType That you want to Change.
Warning: Data May be lost if un-compatible size.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers