Problem in table in SQL server 2008

Asked By Kristine Soliven 0 points N/A Posted on - 03/11/2012

Hello,

I made a mistake in a Table (allowing 2 Not Nulls in there and I to take them off). I tried to take them off but the program won't let me. Anyidea?

Also I deleted a Table named xxx and when I create a new table also named xxx, it said the table already existed (it doesn't show xxx) How do I fix this problem?

Thanks.

• Status: Open
• Question Views: 832
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By bonifacekimeu 0 points N/A #113879

Problem in table in SQL server 2008

The Alter Column statement will help. We use the same syntax for SQL Server 2005 and SQL Server 2008 but 2008 allows the sparse attribute to be changed.

ALTER TABLE table_name
DROP COLUMN column_nam

Remember:

• Only the data type, sparse attribute (2008) and the Null able attribute of a column can be changed.
• You cannot add a NOT NULL specification if NULL values exist.
• In order to change or add a default value of a column, you need to use   Add/Drop Constraint.
• In order to rename a column, you must use sp_rename

About bonifacekimeu

Questions
0

Answers
31

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 03/12/2012
• Question Category: MS SQL Server

Answered By Kristine Soliven 0 points N/A #113881

Problem in table in SQL server 2008

Thanks Bonifacekemiru,

 

I altered the table using the command you posted ALTER TABLE [ database_name. [ schema_name ]. | schema_name.] table_name {ALTER COLUMN column_name { [type_schema_name.] type_name [({precision [scale] | max | xml_schema_collection } ) ] [ COLLATE collation_name ] [ NULL | NOT NULL ] [ SPARSE ] | {ADD | DROP } { ROWGUIDCOL | PERSISTED | NOT FOR REPLICATION | SPARSE } } | [ WITH { CHECK | NOCHECK } ] | DROP { [ CONSTRAINT ] constraint_name [ WITH ( [ ,…n ] ) ] | COLUMN column_name } [ ,…n ]. Done, I take them off! Thank you very much!

About Kristine Soliven

Questions
9

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/09/2012
• Question Category: MS SQL Server