Home / Questions / 362474
Accepted
Richard Víquez Pérez
Asked: 2020-06-05 16:04:05 +0800 CST 2020-06-05 16:04:05 +0800 CST

Syntax problem in sql server

  • 772

I want to create a view with this statement:

CREATE OR REPLACE VIEW prueba  as select * from company.alarma

but it says there is a syntax error. What is the problem? Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'REPLACE'.

sql

1 Answers

  1. Best Answer

    It was solved like this:

    CREATE OR ALTER VIEW {nombre} AS  {select statement} as {un nombrecualquiera};
    • 0