Transact-SQL 语法约定 语法 syntaxsql 复制 DROP SYNONYM [ IF EXISTS ] [ schema. ] synonym_name 参数 IF EXISTS 适用范围:SQL Server(SQL Server 2016 (13.x) 到当前版本)。 只有在同义词已存在时才对其进行有条件地删除。 架构 指定同义词所在的架构。 如果未指定架构,SQL Server 将使用当前用户的默...
in a future version of SQL Server. Avoid using this syntax in new development work, and plan to modify applications that currently use the feature. Use the syntax specified under<drop_relational_or_xml_or_spatial_index>instead. XML indexes can't be dropped using backward compatible syntax. ...
Azure SQL 数据库的语法。 syntaxsql DROPINDEX{<drop_relational_or_xml_or_spatial_index>[ , ...n ] }<drop_relational_or_xml_or_spatial_index>::=index_nameON::={database_name.schema_name.table_or_view_name|schema_name.table_or_view_name|table_or_view_name} Azure Synapse Analytics...
适用于:SQL Server Azure SQL 数据库 Azure SQL 托管实例 Azure Synapse Analytics Microsoft Fabric SQL 数据库 从当前数据库中删除对称密钥。 Transact-SQL 语法约定 备注 Azure Synapse Analytics 中的无服务器 SQL 池不支持此语法。 语法 syntaxsql 复制 DROP SYMMETRIC KEY symmetric_key_name [REMOVE PROVIDER...
"Syntax for Schema Objects and Parts in SQL Statements"for information on referring to database links subquery_restriction_clause Use thesubquery_restriction_clauseto restrict the subquery in one of the following ways: WITHREADONLYspecifies that the subquery cannot be updated. ...
Syntax error in DROP TABLE or DROP INDEX. (Error 3295)Article 06/14/2014 Expand table You entered an SQL statement that has an invalid DROP statement. Possible causes: A reserved word or argument name is misspelled or missing. Punctuation is incorrect....
Syntax Drop_Function_Statement := 'DROP' 'FUNCTION' ['IF' 'EXISTS']Identifier. Remarks Identifier Specifies the name of the table-valued function. If theIdentifieris a three-part identifier, the function will be dropped in the specified database and schema. If it is a two-part identifier,...
syntaxsql sp_dropserver[ @server = ]N'server'[ , [ @droplogins = ]'droplogins'] [ ; ] 参数 [ @server = ] N'server' 要删除的服务器。@server为sysname,无默认值。@server必须存在。 [ @droplogins = ] 'droplogins' 指示如果指定了@droplogins,还必须删除@server的相关远程和链接服务器登录名...
DROP FULLTEXT INDEX (Transact-SQL) Artikel 22.12.2023 10 Mitwirkende Feedback In diesem Artikel Syntax Argumente Bemerkungen Berechtigungen 2 weitere anzeigen Gilt für:SQL ServerAzure SQL-DatenbankAzure SQL Managed Instance Entfernt einen Volltextindex aus einer angegebenen Tabelle oder ...
CREATE DATABASESyntax CREATE DATABASE [IF NOT EXISTS] db_name CREATE DATABASEcreates a database with the given name. Rules for allowable database names are given inSection 6.1.2. An error occurs if the database already exists and you didn’t specifyIF NOT EXISTS. ...