Modifying tables which has data

Results 1 to 3 of 3

Thread: Modifying tables which has data

  1. #1
    Join Date
    Dec 1969

    Default Modifying tables which has data

    Hello,<BR> I am using SQL Server 7.0 as backend database. I have many existing datas in the table and i need to modify the table structure with not null columns, when i have data in the table i am not able to modify the table and if i copy the data to some other place and do the modification and then try to paste also, it is not allowing me to paste it again, can anyone let me know how to solve this problem....<BR><BR>Thank you,<BR>Keerthi

  2. #2
    MG Guest

    Default RE: Modifying tables which has data

    How are you modifying the tables. I use Enterprise Manager and have never had a problem modifying the tables on the fly.

  3. #3 Guest

    Default RE: Modifying tables which has data

    If you are trying to mod your column to not null, then obviously if you already have rows nulls in that column, then you have a conflict.<BR><BR>When you remove the contents to a temp table (as you seem to be saying), of course you will be able to modify the empty table. Then when you try to bring the data back, the "not null" constraint will not allow you to include lines which have blanks in that column.<BR><BR>The solution is that you must put some values in the null column!

Posting Permissions

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