The SQL enterprise manager script generation function is used to generate some view generation scripts to the client the other day.
However, there is a view named [Print _ sender information]
The "Print _" is automatically removed from the statement for generating the script to create the view. Other statements with the "Print _ XXXX" view are no problem.
The automatically generated script is as follows:
If exists (select * From DBO. sysobjects where id = object_id (n' [DBO]. [Print _ sender information] ') and objectproperty (ID, N 'isview') = 1)
Drop view [DBO]. [Print _ sender information]
Go
Set quoted_identifier on
Go
Set ansi_nulls on
Go
Create view DBO. Sender Information
As
Select ccname as sender name, printcfullname as sender's organization, ctel as sender's phone number,
Caccounts as sender account, caddress as sender address, cCity as sender city,
Cpostcode as sender zip code
From DBO. ctype
Go
Set quoted_identifier off
Go
Set ansi_nulls on
Go