Hi @Chris Slinko ,
Welcome to the microsoft TSQL Q&A forum!
Guoxiong has already explained the reason for the error. In addition, I want to add that please check again whether the database name you want to use is Views. If it is View, if you enter Views, similar errors will be returned.
The reason for this error is: CREATE TABLE statement will create a new table, if the table already exists before, it will return the above error.In other words, before running
CREATE TABLE [dbo].[VW_vision_for_fire]. . .
Statement, the [dbo].[VW_vision_for_fire] table already exists in your database. It is also possible that you have repeatedly executed
CREATE TABLE [dbo].[VW_vision_for_fire]. . .
To solve this problem, just execute DROP TABLE npub_info before executing CREATE TABLE [dbo].[VW_vision_for_fire]...
If you have any question, please feel free to let me know.
If the response is helpful, please click "Accept Answer" and upvote it.
Regards
Echo
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.