The right way to create a system object (Desk, Saved Process, View…)


It’s very easy. You simply want so as to add the article identify as a parameter to “SYS.SP_MS_MARKSYSTEMOBJECT”. Within the following code we’re making a system desk named“TestSysTable”:

 

IF OBJECT_ID(N’TestSysTable’) IS NULL

start

              CREATE TABLE dbo.TestSysTable

              (

                     C1 int NOT NULL,

                     C2 int NOT NULL,

                     C3 int PRIMARY KEY IDENTITY

                    

              )

EXEC SYS.SP_MS_MARKSYSTEMOBJECT ‘TestSysTable’

Finish

 

All executed!

Get pleasure from!



Supply hyperlink

Leave a Reply

Your email address will not be published. Required fields are marked *