Hi,
I got a message "incorrect syntax SP_DROPOBJECTDEF " from running below code. Please someone can help me to make correction. Thanks in advance. Mike
/* sql code */
IF OBJECT_ID('OTLT') IS NOT NULL
BEGIN
DROP VIEW OTLT
SP_DROPOBJECTDEF 'OTLT' /* deletes the CIS mapping */
IF OBJECT_ID('OTLT') IS NOT NULL
PRINT '<<< FAILED DROPPING view OTLT >>>'
ELSE
PRINT '<<< DROPPED view OTLT >>>'
END
go
I got a message "incorrect syntax SP_DROPOBJECTDEF " from running below code. Please someone can help me to make correction. Thanks in advance. Mike
/* sql code */
IF OBJECT_ID('OTLT') IS NOT NULL
BEGIN
DROP VIEW OTLT
SP_DROPOBJECTDEF 'OTLT' /* deletes the CIS mapping */
IF OBJECT_ID('OTLT') IS NOT NULL
PRINT '<<< FAILED DROPPING view OTLT >>>'
ELSE
PRINT '<<< DROPPED view OTLT >>>'
END
go