Alter table fails

Question

Viewing 5 posts - 1 through 5 (of 5 total)

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

Jeffrey Williams SSC Guru Points: 90351 More actions · Answer 1

You need to separate out each call using the batch terminator GO. So you need:

SELECT ... FROM ...

GO

ALTER TABLE ...

GO

SELECT ... FROM ...

GO

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

Edvard Korsbæk SSCertifiable Points: 5999 More actions · Answer 2

If I add 'Go'

SELECT is_Nullable FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '3NF_Medarbejder' AND COLUMN_NAME = 'Fornavn'

GO

ALTER TABLE 3NF_Medarbejder

ALTER COLUMN fornavn NULL

GO

SELECT is_Nullable FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '3NF_Medarbejder' AND COLUMN_NAME = 'Fornavn'

Line 1 and line 6 executes, but line s fails with:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '3'.

i.e. its the Alter Table that fails, but I still cannot figure out why

Edvard Korsbæk

Jeffrey Williams SSC Guru Points: 90351 More actions · Answer 3

Because a table name cannot start with a number, unless you quote it. You can quote it using either brackets or double-quotes. For example:

ALTER TABLE [3NF_Medarbejder] ALTER COLUMN fornavn datatype NULL;

You also need to specify the data type for the column.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

Edvard Korsbæk SSCertifiable Points: 5999 More actions · Answer 4

Thanks!

Did the trick

A newbie is a newbie untill an expert has converted:-)

Edvard Korsbæk