(1) .-PUBLIC-. >>-CREATE--+---+---+-+--SYNONYM--+---+--synonym--FOR--+-table---+->< | (1) | '-IF NOT EXISTS-' +-view---+ '---PRIVATE---' '-sequence-' 注: このキーワードは、ANSI/ISO 準拠ではないデータベースでのみ有効です。 要素説明制約事項構文 sequence...
If you are creating a synonym for a procedure or function on a remote database, then you must specifyschemain thisCREATEstatement. Alternatively, you can create a local public synonym on the database where the object resides. However, the database link must then be included in all subsequent ...
CREATE SYNONYM creates a synonym object. A synonym is an alias of a database object and is used to record the mapping between database object names. You can use synonyms
Use the CREATE SYNONYM statement to declare and register an alternative name for an existing table, view, or sequence object. This statement is an extension to the ANSI/ISO standard for SQL. Syntax CREATE 1 PUBLIC 1 PRIVATE SYNONYMIF NOT EXISTSsynonymFOR ...
Similarly, you cannot create a table or view with a name that matches a synonym already present. A synonym can be defined for a table/view that does not exist when you create the synonym. If the table or view doesn't exist, you will receive a warning message (SQLSTATE 01522). The ...
sql> create synonym t1 for ic.t1; create的英语句子 create 的英语句子 关于create 的英语句子 vt. 创造,创作;造成 a kind of warm and intimate atmosphere. 为了创造一个温馨亲密的气氛。 Besides, they are more ready to aept or create new ideas, including teaching. 此外,他们更愿意承受或创造新的...
PUT https://[service name].search.windows.net/synonymmaps/[synonymmap name]?api-version=[api-version] Content-Type: application/json api-key: [admin key] HTTPS is required for all service requests. If the synonym map doesn't exist, it's created. If it already exists, it's updated to...
In this case, the synonym name must not be identical to the name of an existing base table, view table, seuence or a private synonym of the current database user. If a synonym with the same name and the PUBLIC attribute exists, it cannot be accessed by the current database user until...
The name of the synonym, this can be at most a two part name. C# 複製 public Microsoft.SqlServer.TransactSql.ScriptDom.SchemaObjectName Name { get; set; } Property Value SchemaObjectName Applies to 產品版本 Microsoft.SQLServer.DacFx 140.3881.1, 150.18208.0, 160.2004021.0, 161.6374.0,...
SCHEMA is a synonym for CREATE DATABASE.URL: https://dev.mysql.com/doc/refman/8.0/en/create-database.html通过HELP命令,我们查看到数据库创建命令的语句和语法格式。Syntax:CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name[create_option] …create_option: [DEFAULT] {CHARACTER SET [=] charset...