Professional Web Applications Themes

Column property changes. - Microsoft SQL / MS SQL Server

Changing the nullability on a new, nonkey column re-creates the table in the database when you save the table or database diagram using Database Diagrams within SQL Server Enterprise Manager. -- does the preceding statement from Books Online in SQLSrver 2K mean that the data within the table is lost when you modify a table's columns?...

  1. #1

    Default Column property changes.

    Changing the nullability on a new, nonkey column re-creates the table in the
    database when you save the table or database diagram using Database Diagrams
    within SQL Server Enterprise Manager.
    -- does the preceding statement from Books Online in SQLSrver 2K mean that
    the data within the table is lost when you modify a table's columns?


    JPM Guest

  2. #2

    Default Re: Column property changes.

    No, SQL Server creates a copy of the table that includes the changes and
    copies the data from the original table to that new table. It then drops the
    original table and renames the new table so it has the name of the original
    table.

    If you want to see what SQL is used to accomplish this you can click on the
    'Save change script' button on the toolbar (4th from the left)

    "JPM" <com> wrote in message
    news:%phx.gbl... 
    the 
    Diagrams 


    Jacco Guest

Similar Threads

  1. strok property in column chart
    By smonika15 in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: May 8th, 02:51 PM
  2. button column's text property
    By Volkan Karaboša in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: October 22nd, 07:23 AM
  3. SET IDENTITY PROPERTY OF COLUMN?
    By Vishal in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 14th, 02:50 PM
  4. Replies: 1
    Last Post: July 14th, 02:56 AM
  5. Column Property
    By Coulmn Property in forum Microsoft Access
    Replies: 1
    Last Post: July 9th, 02:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139