Post reply

ALTER Table

  • September 5, 2005 at 8:48 am

    #91057

    I have a couple of questions regardng ALTER Table.

    1)  How do I add DEFAULT -1 to

    ALTER TABLE [dbo].[xtable]  ADD

     

  • September 5, 2005 at 8:52 am

    #587604

    ALTER TABLE dbo.xTable ADD CONSTRAINT

    DF_name DEFAULT 'Yourvalue' FOR YourTable

    GO

  • September 5, 2005 at 9:36 am

    #587607

    Thanks.

    I guess part of my Post got cut off.

    Another question.

    With ALTER TABLE, can I change the name of a column?  Like xtable.xcolumn to xtable.zcolumn.

    Phil

     

     

  • September 5, 2005 at 9:50 am

    #587610

    exec sp_rename 'tablename.colname', 'newcolname', 'COLUMN'

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply