How to fix parse error which I get like this?

Question

I am getting error like 
ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Parse error at line: 14, column: 33: Incorrect syntax near 'ID'.

My schema is
create TABLE [dbo].[op]

(

	[P ID] [int] NULL,
	[col1] [varchar](700) NULL,
	[ID] [bigint] NULL,
	[Col2] [varchar](700) NULL,
	[Col3] [int] NULL,
	[col4] [varchar](700) NULL,
	[Col5] [varchar](700) NULL,
	[Col6] [varchar](700) NULL,
	[Col7] [varchar](700) NULL,
	[Col8] [varchar](700) NULL,
	[event_timestamp] [datetime2](7) NULL

)

WITH

(

	DISTRIBUTION = ROUND_ROBIN,
	CLUSTERED INDEX

	(

		[P ID] ASC

	)

)

GO

But i dont see any issues here.

Answer 1

Hi

Thanks for reaching out to Microsoft Q&A.

Error says its a syntax error.

Change [P ID] as [P_ID] and try executing the query. Let me know if this worked.

Please Upvote and Accept as answer if the reply was helpful, this will be helpful to other community members.