How to sort sql columns in alter table

Question

How to sort sql columns in alter table

Navigation

#1 by (3 votes)

2

I have a change to make in the table Inclusão de colunas the doubt is how do I set the order when I am making the change in sql server 2008?

ALTER TABLE dbo.Arquivos 
ADD IdTipoDocumento int NULL, -- order 3
    NomeInterno nvarchar(200) NULL, -- order 4
    DirArquivo nvarchar(200) NULL,-- order 5
    DescrArquivo nvarchar(max) NULL, -- order 6
    LarguraArquivo int NULL, -- order 12
    AlturaArquivo int NULL, --  order 13
    FlagAtivo bit NULL, -- order 14
    IdUsuarioUpload int NULL, -- order 15
    DtInclusao datetime NULL -- order 16

sql-server

asked by anonymous 12.11.2015 / 13:20

1 answer

Error activating WP_DEBUG Select only one item

score 3 · Accepted Answer

Yes, SQL Server Management Studio . By Transact-SQL this is not possible.

For the database, the order of the columns is irrelevant. This functionality can be considered even cosmetic, since it does not affect the performance or operation of the table in any way.