CODEWITHSUNDEEP
sql-server-2008
jerofad
jerofad

Reputation: 11

Alter table and modify column

I want to modify a particular column in a table and i use this but there is a red line under modify and 4. please help

ALTER TABLE COURSEINFO_TBL MODIFY 
COLUMN CRS_GP DECIMAL(4,1) NOT NULL;

Upvotes: 0

Views: 104

Answers (2)

Ashutosh Arya
Ashutosh Arya

Reputation: 1168

Please go for 

   ALTER TABLE COURSEINFO_TBL ALTER COLUMN CRS_GP DECIMAL(4,1) NOT NULL

Upvotes: 0

juergen d
juergen d

Reputation: 204746

ALTER TABLE COURSEINFO_TBL 
ALTER COLUMN CRS_GP DECIMAL(4,1) NOT NULL;

Upvotes: 3

Related Questions