Results 1 to 5 of 5
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168

    Unable to insert column into table, but can add to end?


    Trying to make changes to a table in SQL Server and when I trying to insert a column (not at the very top, about 3 down) it wont let me save the table saying

    however if I just add the column to the bottom of the table it saved it just fine??
    Just curious as to why.

    Note: the Column was

    BankTypeID int Allow Nulls Yes


    it will be the foreign key from another table that I had created.

  2. #2
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Is this in SSMS ? What error do you get? I've just tried it and it worked, right click ¬ Insert Column

    Add it at the bottom save, then drag and drop it up to where you want it?
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Look in the SSMS in the menu Tools -> Options tab Designers and uncheck Prevent saving changes that require table re-ceation when it's on. That being said, the column order in the table has no importance at all.
    Click image for larger version. 

Name:	SQL_SSMS_Options.JPG 
Views:	21 
Size:	57.8 KB 
ID:	45824

  4. #4
    Join Date
    Oct 2021
    Posts
    9
    MS SQL doesn’t allow you add column in middle of table due to their structure. MySQL does allow you to add columns in middle of table.

    If the column order display really matters, you can create a view and specify the preferred order.

  5. #5
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    In SQL server Management Studio you can add the columns where you want: you can drag them up and down like you want, but the point is: the column order in a table just doesn't matter. Just like the record order doesn't matter. They are determined by the way you create your queries.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Unable to Sort A Column Using Macro
    By DigitalAdrenaline in forum Macros
    Replies: 3
    Last Post: 08-27-2016, 08:59 PM
  2. Replies: 1
    Last Post: 01-02-2015, 05:04 PM
  3. Insert Column between existing columns?
    By JC8865 in forum Access
    Replies: 2
    Last Post: 12-06-2014, 09:05 PM
  4. Column assignments in an INSERT INTO type of query.
    By tfulmer in forum Import/Export Data
    Replies: 3
    Last Post: 05-01-2013, 01:42 PM
  5. Replies: 6
    Last Post: 11-14-2012, 01:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums