Can i use Default in Alter Statements

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Can i use Default in Alter Statements

Can i use Default in Alter Statements

Rate Topic

Display Mode

Topic Options

Author

Message

Pulivarthi Sasidhar

Posted Tuesday, April 20, 2010 12:42 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 5:30 AM
Points: 870, Visits: 522

hi,

I am having a table. which is taking by default NULL values...

Now i want to update the Column default to'XXXX'
Script:-

CREATE TABLE [dbo].[Testowners](
[owner_id] [int] NULL,
[owname] [varchar](15) NULL
)

Alter Script 1:-
ALTER TABLE Owners
ALTER Column [owner_id] INT NOT NULL

Alter Script 2:-
ALTER TABLE Owners
ALTER Column owname VARCHAR(35) Default 'XX'

The first Alter Statement is working fine.
Cant i use the Default in Alter statement ....

Thnaks in advance.......

Post #906571

Pulivarthi Sasidhar

Posted Tuesday, April 20, 2010 12:54 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 5:30 AM
Points: 870, Visits: 522

I got solution......... BigGrin

ALTER Table Owners
ADD CONSTRAINT con_owname DEFAULT 'XXX' FOR owname

But Y dont we use Default in the Alter statement. Event the below link shows it in Syntax...by SET Default...

http://msdn.microsoft.com/en-us/library/ms174123.aspx

Post #906576

Paul White

Posted Tuesday, April 20, 2010 5:43 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 4:22 PM
Points: 10,990, Visits: 10,542

That is the Books Online entry for SQL Server Compact 3.5 Service Pack 1.
You want the SQL Server 2008 entry:
http://msdn.microsoft.com/en-us/library/ms190273.aspx

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #906727

« Prev Topic | Next Topic »

Permissions