Questions tagged [alter-column]

Alter column is a part of sql's Alter table statement used to change an existing column in a table.

Alter column can be used to set a default value, changing the column's data type, or changing the column's maximum length.

Alter column is supported in Microsoft Access and in Sql Server. To modify columns properties in Oracle, for example, you will need to use Modify column instead.

Alter column related tags

62 questions
-1
votes
1 answer

How can I ALTER COLUMN to NULL when the column in NOT NULL in Oracle

How can I ALTER COLUMN to NULL when the column in NOT NULL in Oracle, with a sentence or script?
-2
votes
2 answers

I get "ORA-00900: invalid SQL statement" error while modifying column

I have this code in SQL developer: create table course_table ( course_id number(5) not null, course_name varchar2(25) not null, course_hours number(1) not null, department varchar2(10) not null, description varchar2(50) not…
Faraz
  • 6,025
  • 5
  • 31
  • 88
1 2 3 4
5