SQL Server 2016新特性:DROP IF EXISTS
发布网友
发布时间:2024-10-20 07:41
我来回答
共1个回答
热心网友
时间:2024-11-15 16:45
DROPobject_typeIFEXISTSobject_name
能够用于DROP的object_type,如Tables, Database, Function, Trigger, Stored Procere, Column, User, Type, View, Schema,皆可套用,比如:
ALTER TABLE PERSONDROP COLUMN If EXISTS NAME
SQL Server 2016新特性:DROP IF EXISTS
标签:basesysges.netschfunctionnameexists删除