SnowConvert: Transactシステムテーブル

システムテーブル

Transact-SQLSnowflake SQLNotes
SYS.ALL_VIEWSINFORMATION_SCHEMA.VIEWS
SYS.ALL_COLUMNSINFORMATION_SCHEMA.COLUMNS
SYS.COLUMNSINFORMATION_SCHEMA.COLUMNS
SYS.OBJECTSINFORMATION_SCHEMA.OBJECT_PRIVILEGES
SYS.PROCEDURESINFORMATION_SCHEMA.PROCEDURES
SYS.SEQUENCESINFORMATION_SCHEMA.SEQUENCES
SYS.ALL_OBJECTSINFORMATION_SCHEMA.OBJECT_PRIVILEGES
ALL_PARAMETERSNot supported
SYS.ALL_SQL_MODULESNot supported
SYS.ALLOCATION_UNITSNot supported
SYS.ASSEMBLY_MODULESNot supported
SYS.CHECK_CONSTRAINTSNot supported
SYS.COLUMN_STORE_DICTIONARIESNot supported
SYS.COLUMN_STORE_ROW_GROUPSNot supported
SYS.COLUMN_STORE_SEGMENTSNot supported
SYS.COMPUTED_COLUMNSNot supported
SYS.DEFAULT_CONSTRAINTSNot supported
SYS.EVENTSNot supported
SYS.EVENT_NOTIFICATIONSNot supported
SYS.EVENT_NOTIFICATION_EVENT_TYPESNot supported
SYS.EXTENDED_PROCEDURESNot supported
SYS.EXTERNAL_LANGUAGE_FILESNot supported
SYS.EXTERNAL_LANGUAGESNot supported
SYS.EXTERNAL_LIBRARIESNot supported
SYS.EXTERNAL_LIBRARY_FILESNot supported
SYS.FOREIGN_KEYSINFORMATION_SCHEMA.TABLE_CONSTRAINTS
SYS.FOREIGN_KEY_COLUMNSNot supported
SYS.FUNCTION_ORDER_COLUMNSNot supported
SYS.HASH_INDEXESNot supported
SYS.INDEXESNot supported
SYS.INDEX_COLUMNSNot supported
SYS.INDEX_RESUMABLE_OPERATIONSNot supported
SYS.INTERNAL_PARTITIONSNot supported
SYS.INTERNAL_TABLESNot supported
SYS.KEY_CONSTRAINTSNot supported
SYS.MASKED_COLUMNSNot supported
SYS.MEMORY_OPTIMIZED_TABLES_INTERNAL_ATTRIBUTESNot supported
SYS.MODULE_ASSEMBLY_USAGESNot supported
SYS.NUMBERED_PROCEDURESNot supported
SYS.NUMBERED_PROCEDURE_PARAMETERSNot supported
SYS.PARAMETERSNot supported
SYS.PARTITIONSNot supported
SYS.PERIODSNot supported
SYS.SERVER_ASSEMBLY_MODULESNot supported
SYS.SERVER_EVENTSNot supported
SYS.SERVER_EVENTT_NOTIFICATIONSNot supported
SYS.SERVER_SQL_MODULENot supported
SYS.SERVER_TRIGGERSNot supported
SYS._SERVER_TRIGGER_EVENTSNot supported
SYS.SQL_DEPENDENCIESNot supported
SYS.SQL_EXPRESSION_DEPENDENCIESNot supported
SYS.SQL_MODULESNot supported
SYS.STATSNot supported
SYS.STATS_COLUMNSNot supported
SYS.SYNONYMSNot supported
SYS.SYSTEM_COLUMNSNot supported
SYS.SYSTEM_OBJECTSNot supported
SYS.SYSTEM_PARAMETERSNot supported
SYS.SYSTEM_SQL_MODULES"Not supported

既知の問題

問題は見つかりませんでした。

SYS.FOREIGN_KEYS

Applies to

  • [x] SQL Server

  • [x] Azure Synapse Analytics

注釈

わかりやすくするため、出力コードの一部を省略しています。

説明

FOREIGN KEY 制約であるオブジェクトごとの行を含みます(SQLServer ドキュメント)。

FOREIGN KEY （sys.foreign_keys）の列は以下の通りです。

Column nameData typeDescriptionHas equivalent column in Snowflake
<Columns inherited from sys.objects>-For a list of columns that this view inherits, see sys.objects (Transact-SQL).Partial
referenced_object_idintID of the referenced object.No
key_index_idintID of the key index within the referenced object.No
is_disabledbitFOREIGN KEY constraint is disabled.No
is_not_for_replicationbitFOREIGN KEY constraint was created by using the NOT FOR REPLICATION option.No
is_not_trustedbitFOREIGN KEY constraint has not been verified by the system.No
delete_referential_actiontinyintThe referential action that was declared for this FOREIGN KEY when a delete happens. See SQLServer Documentation.No
delete_referential_action_descnvarchar(60)Description of the referential action that was declared for this FOREIGN KEY when a delete occurs. See SQLServer Documentation.No
update_referential_actiontinyintThe referential action that was declared for this FOREIGN KEY when an update happens. See SQLServer Documentation.No
update_referential_action_descnvarchar(60)Description of the referential action that was declared for this FOREIGN KEY when an update happens. See SQLServer Documentation.No
is_system_namedbit

1 = Name was generated by the system.

0 = Name was supplied by the user.

No

sys.objects から継承される列は以下の通りです。

詳細は、 sys.objectsのドキュメント を参照してください。

Column nameData typeDescriptionHas equivalent column in Snowflake
namesysnameObject name.Yes
object_idintObject identification number. Is unique within a database.No
principal_idintID of the individual owner, if different from the schema owner.No
schema_idintID of the schema that the object is contained in.No
parent_object_idintID of the object to which this object belongs.No
typechar(2)Object typeYes
type_descnvarchar(60)Description of the object typeYes
create_datedatetimeDate the object was created.Yes
modify_datedatetimeDate the object was last modified by using an ALTER statement.Yes
is_ms_shippedbitObject is created by an internal SQL Server component.No
is_publishedbitObject is created by an internal SQL Server component.No
is_schema_publishedbitOnly the schema of the object is published.No

この場合、sys.foreign_keysについては、Snowflakeには同等のものがないことに注意してください。しかし、等価性はsys.objectsから継承された列の基になります。

適用可能な列の等価性

SQLServerSnowflakeLimitationsApplicable
nameCONSTRAINT_NAMENames auto-generated by the database may be reviewed to the target Snowflake auto-generated name,Yes
typeCONSTRAINT_TYPEThe type column has a variety of options. But, in this case, the support is only for the letter 'F' which represents the foreign keys.No. Because of the extra validation to determine the foreign keys from all table constraints, it is not applicable.
type_descCONSTRAINT_TYPENo limitions found.No. Because of the extra validation to determine the foreign keys from all table constraints, it is not applicable.
create_dateCREATEDData type differences.Yes
modify_dateLAST_ALTEREDData type differences.Yes
parent_object_idCONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, TABLE_NAMEColumns are generated only for the cases that use the OBJECT_ID() function and, the name has a valid pattern.Yes
SQL Serverでの構文
 SELECT ('column_name' | * )
FROM sys.foreign_keys;
Copy
Snowflakeの構文
 SELECT ('column_name' | * )
FROM information_schema.table_constraints 
WHERE CONSTRAINT_TYPE = 'FOREIGN KEY';
Copy

注釈

システム外部キーの等価性は、Snowflakeのin ormation_schema.table_constraintsのカタログビューであるため、外部キー制約を他の制約から識別するには、追加の「WHERE」句で制約のタイプを定義する必要があります。

サンプルソースパターン

以下のサンプル（パターン番号3を除く）を正しく実行するには、以下のステートメントを実行する必要があります。

 CREATE TABLE Customers (
    CustomerID INT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50),
    Email VARCHAR(100)
);

CREATE TABLE Orders (
    OrderID INT PRIMARY KEY,
    CustomerID INT,
    OrderDate DATE,
    TotalAmount DECIMAL(10, 2),
    CONSTRAINT FK_Name_Test FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)
);


INSERT INTO Customers (CustomerID, FirstName, LastName, Email)
VALUES
    (1, 'John', 'Doe', 'john.doe@example.com'),
    (2, 'Jane', 'Smith', 'jane.smith@example.com');

INSERT INTO Orders (OrderID, CustomerID, OrderDate, TotalAmount)
VALUES
    (101, 1, '2023-09-01', 100.50),
    (102, 1, '2023-09-02', 75.25),
    (103, 2, '2023-09-03', 50.00);
Copy
 CREATE OR REPLACE TABLE Customers (
    CustomerID INT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50),
    Email VARCHAR(100)
)
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"transact"}}'
;

CREATE OR REPLACE TABLE Orders (
    OrderID INT PRIMARY KEY,
    CustomerID INT,
    OrderDate DATE,
    TotalAmount DECIMAL(10, 2),
       CONSTRAINT FK_Name_Test FOREIGN KEY (CustomerID) REFERENCES Customers (CustomerID)
   )
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"transact"}}'
;

INSERT INTO Customers (CustomerID, FirstName, LastName, Email)
VALUES
    (1, 'John', 'Doe', 'john.doe@example.com'),
    (2, 'Jane', 'Smith', 'jane.smith@example.com');

INSERT INTO Orders (OrderID, CustomerID, OrderDate, TotalAmount)
VALUES
    (101, 1, '2023-09-01', 100.50),
    (102, 1, '2023-09-02', 75.25),
    (103, 2, '2023-09-03', 50.00);
Copy

1.単純な選択ケース

SQL Server
 SELECT *
FROM sys.foreign_keys;
Copy
nameobject_idprincipal_idschema_idtypetype_desccreate_datemodify_dateparent_object_idis_ms_shippedis_publishedis_schema_publishedreferenced_object_idkey_index_idis_disabledis_not_for_replicationis_not_trusteddelete_referential_actiondelete_referential_action_descupdate_referential_actionupdate_referential_action_descis_system_named
FK_Name_Test1719677174NULL1FFOREIGN_KEY_CONSTRAINT2023-09-11 22:20:04.1602023-09-11 22:20:04.1601687677060falsetruefalse16556769461falsefalse0NO_ACTION0NO_ACTIONtrue
Snowflake
 SELECT *
FROM
INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE
CONSTRAINT_TYPE = 'FOREIGN KEY';
Copy
CONSTRAINT_CATALOGCONSTRAINT_SCHEMACONSTRAINT_NAMETABLE_CATALOGTABLE_SCHEMATABLE_NAMECONSTRAINT_TYPEIS_DEFERRABLEINITIALLY_DEFERREDENFORCEDCOMMENTCREATEDLAST_ALTEREDRELY
DBTESTPUBLICFK_Name_TestDATETESTPUBLICORDERSFOREIGN KEYNOYESNOnull2023-09-11 15:23:51.969 -07002023-09-11 15:23:52.097 -0700NO

警告

列のオブジェクトの違いや等価性の欠落により、結果は異なります。結果を確認することができます。

2.名前列ケース

SQL Server
 SELECT * FROM sys.foreign_keys WHERE name = 'FK_Name_Test';
Copy
nameobject_idprincipal_idschema_idtypetype_desccreate_datemodify_dateparent_object_idis_ms_shippedis_publishedis_schema_publishedreferenced_object_idkey_index_idis_disabledis_not_for_replicationis_not_trusteddelete_referential_actiondelete_referential_action_descupdate_referential_actionupdate_referential_action_descis_system_named
FK_Name_Test1719677174NULL1FFOREIGN_KEY_CONSTRAINT2023-09-11 22:20:04.1602023-09-11 22:20:04.1601687677060falsetruefalse16556769461falsefalse0NO_ACTION0NO_ACTIONtrue
Snowflake
 SELECT * FROM
INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE
CONSTRAINT_NAME = 'FK_NAME_TEST'
AND CONSTRAINT_TYPE = 'FOREIGN KEY';
Copy
CONSTRAINT_CATALOGCONSTRAINT_SCHEMACONSTRAINT_NAMETABLE_CATALOGTABLE_SCHEMATABLE_NAMECONSTRAINT_TYPEIS_DEFERRABLEINITIALLY_DEFERREDENFORCEDCOMMENTCREATEDLAST_ALTEREDRELY
DBTESTPUBLICFK_Name_TestDATETESTPUBLICORDERSFOREIGN KEYNOYESNOnull2023-09-11 15:23:51.969 -07002023-09-11 15:23:52.097 -0700NO

警告

制約名がデータベースによって自動生成され、クエリで使用される場合、この翻訳には検証が必要になることがあります。詳細情報については、 既知の問題セクションを参照してください。

3.親オブジェクト ID ケース

この例では、異なる列と同等の列を作成するための名前の処理を例示するために、データベースとスキーマを作成しました。

SQL Server
 use database_name_test
create schema schema_name_test

CREATE TABLE schema_name_test.Customers (
    CustomerID INT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50),
    Email VARCHAR(100)
);

CREATE TABLE schema_name_test.Orders (
    OrderID INT PRIMARY KEY,
    CustomerID INT,
    OrderDate DATE,
    TotalAmount DECIMAL(10, 2),
    CONSTRAINT FK_Name_Test FOREIGN KEY (CustomerID) REFERENCES schema_name_test.Customers(CustomerID)
);

INSERT INTO schema_name_test.Customers (CustomerID, FirstName, LastName, Email)
VALUES
    (1, 'John', 'Doe', 'john.doe@example.com'),
    (2, 'Jane', 'Smith', 'jane.smith@example.com');

INSERT INTO schema_name_test.Orders (OrderID, CustomerID, OrderDate, TotalAmount)
VALUES
    (101, 1, '2023-09-01', 100.50),
    (102, 1, '2023-09-02', 75.25),
    (103, 2, '2023-09-03', 50.00);

SELECT * FROM sys.foreign_keys WHERE name = 'FK_Name_Test' AND parent_object_id = OBJECT_ID(N'database_name_test.schema_name_test.Orders')
Copy
nameobject_idprincipal_idschema_idtypetype_desccreate_datemodify_dateparent_object_idis_ms_shippedis_publishedis_schema_publishedreferenced_object_idkey_index_idis_disabledis_not_for_replicationis_not_trusteddelete_referential_actiondelete_referential_action_descupdate_referential_actionupdate_referential_action_descis_system_named
FK_Name_Test1719677174NULL1FFOREIGN_KEY_CONSTRAINT2023-09-11 22:20:04.1602023-09-11 22:20:04.1601687677060falsetruefalse16556769461falsefalse0NO_ACTION0NO_ACTIONtrue
Snowflake
 USE DATABASE database_name_test;

CREATE OR REPLACE SCHEMA schema_name_test
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},"attributes":{"component":"transact"}}'
;

CREATE OR REPLACE TABLE schema_name_test.Customers (
    CustomerID INT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50),
    Email VARCHAR(100)
)
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},"attributes":{"component":"transact"}}'
;

CREATE OR REPLACE TABLE schema_name_test.Orders (
    OrderID INT PRIMARY KEY,
    CustomerID INT,
    OrderDate DATE,
    TotalAmount DECIMAL(10, 2),
       CONSTRAINT FK_Name_Test FOREIGN KEY (CustomerID) REFERENCES schema_name_test.Customers (CustomerID)
   )
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},"attributes":{"component":"transact"}}'
;

INSERT INTO schema_name_test.Customers (CustomerID, FirstName, LastName, Email)
VALUES
    (1, 'John', 'Doe', 'john.doe@example.com'),
    (2, 'Jane', 'Smith', 'jane.smith@example.com');

INSERT INTO schema_name_test.Orders (OrderID, CustomerID, OrderDate, TotalAmount)
VALUES
    (101, 1, '2023-09-01', 100.50),
    (102, 1, '2023-09-02', 75.25),
    (103, 2, '2023-09-03', 50.00);

SELECT * FROM
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE
    CONSTRAINT_NAME = 'FK_NAME_TEST'
    AND CONSTRAINT_CATALOG = 'DATABASE_NAME_TEST'
    AND CONSTRAINT_SCHEMA = 'SCHEMA_NAME_TEST'
    AND TABLE_NAME = 'ORDERS'
    AND CONSTRAINT_TYPE = 'FOREIGN KEY';
Copy
CONSTRAINT_CATALOGCONSTRAINT_SCHEMACONSTRAINT_NAMETABLE_CATALOGTABLE_SCHEMATABLE_NAMECONSTRAINT_TYPEIS_DEFERRABLEINITIALLY_DEFERREDENFORCEDCOMMENTCREATEDLAST_ALTEREDRELY
DATABASE_NAME_TESTSCHEMA_NAME_TESTFK_Name_TestDATABASE_NAME_TESTSCHEMA_NAME_TESTORDERSFOREIGN KEYNOYESNOnull2023-09-11 15:23:51.969 -07002023-09-11 15:23:52.097 -0700NO

警告

OBJECT_ID()関数の中に入ってくる名前が有効なパターンでない場合、特殊文字に対する名前処理の制限により変換されません。

警告

Snowflakeで使用されているデータベースを確認します。

4.型列ケース

SQL Serverの「F」は「外部キー」を意味し、すべてのテーブル制約から外部キーを指定するために、末尾の検証により削除されます。

SQL Server
 SELECT * FROM sys.foreign_keys WHERE type = 'F';
Copy
nameobject_idprincipal_idschema_idtypetype_desccreate_datemodify_dateparent_object_idis_ms_shippedis_publishedis_schema_publishedreferenced_object_idkey_index_idis_disabledis_not_for_replicationis_not_trusteddelete_referential_actiondelete_referential_action_descupdate_referential_actionupdate_referential_action_descis_system_named
FK_Name_Test1719677174NULL3FFOREIGN_KEY_CONSTRAINT2023-09-11 22:20:04.1602023-09-11 22:20:04.1601687677060falsetruefalse16556769461falsefalse0NO_ACTION0NO_ACTIONtrue
Snowflake
 SELECT * FROM
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE
    type = 'F' AND CONSTRAINT_TYPE = 'FOREIGN KEY';
Copy
CONSTRAINT_CATALOGCONSTRAINT_SCHEMACONSTRAINT_NAMETABLE_CATALOGTABLE_SCHEMATABLE_NAMECONSTRAINT_TYPEIS_DEFERRABLEINITIALLY_DEFERREDENFORCEDCOMMENTCREATEDLAST_ALTEREDRELY
DBTESTPUBLICFK_Name_TestDATETESTPUBLICORDERSFOREIGN KEYNOYESNOnull2023-09-11 15:23:51.969 -07002023-09-11 15:23:52.097 -0700NO

5.型Desc列ケース

「type_desc」列は、すべてのテーブル制約から外部キーを指定するために、末尾の検証により削除されます。

SQL Server
 SELECT
    * 
FROM
    sys.foreign_keys 
WHERE 
    type_desc = 'FOREIGN_KEY_CONSTRAINT';
Copy
nameobject_idprincipal_idschema_idtypetype_desccreate_datemodify_dateparent_object_idis_ms_shippedis_publishedis_schema_publishedreferenced_object_idkey_index_idis_disabledis_not_for_replicationis_not_trusteddelete_referential_actiondelete_referential_action_descupdate_referential_actionupdate_referential_action_descis_system_named
FK_Name_Test1719677174NULL3FFOREIGN_KEY_CONSTRAINT2023-09-11 22:20:04.1602023-09-11 22:20:04.1601687677060falsetruefalse16556769461falsefalse0NO_ACTION0NO_ACTIONtrue
Snowflake
 SELECT
    *
FROM
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE
    type_desc = 'FOREIGN_KEY_CONSTRAINT' AND CONSTRAINT_TYPE = 'FOREIGN KEY';
Copy
CONSTRAINT_CATALOGCONSTRAINT_SCHEMACONSTRAINT_NAMETABLE_CATALOGTABLE_SCHEMATABLE_NAMECONSTRAINT_TYPEIS_DEFERRABLEINITIALLY_DEFERREDENFORCEDCOMMENTCREATEDLAST_ALTEREDRELY
DBTESTPUBLICFK_Name_TestDATETESTPUBLICORDERSFOREIGN KEYNOYESNOnull2023-09-11 15:23:51.969 -07002023-09-11 15:23:52.097 -0700NO

6.日付列の変更の単純なケース

SQL Server
 SELECT *
FROM sys.foreign_keys
WHERE modify_date = CURRENT_TIMESTAMP;
Copy
The query produced no results.
Copy
Snowflake
 SELECT *
FROM
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE
    LAST_ALTERED = CURRENT_TIMESTAMP()
    AND CONSTRAINT_TYPE = 'FOREIGN KEY';
Copy
The query produced no results.
Copy

7.DATEDIFF()ケースによる日付列の変更

次の例は、sys.objectsから継承されたsys.foreign_keysの列が関数 DATEDIFF の中にある、より複雑なシナリオを示しています。この場合、該当する等価性に対応する引数は、Snowflakeのinformation.schemaの対応する列に変更されます。

SQL Server
 SELECT *
FROM sys.foreign_keys
WHERE DATEDIFF(DAY, modify_date, GETDATE()) <= 30;
Copy
The foreign keys altered in the last 30 days.
Copy
Snowflake
 SELECT *
FROM
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE
    DATEDIFF(DAY, LAST_ALTERED, CURRENT_TIMESTAMP() :: TIMESTAMP) <= 30
    AND CONSTRAINT_TYPE = 'FOREIGN KEY';
Copy
The foreign keys altered in the last 30 days.
Copy

8.日付列の作成ケース

SQL Server
 SELECT *
FROM sys.foreign_keys
WHERE create_date = '2023-09-12 14:36:38.060';
Copy
The foreign keys that were created on the specified date and time.
Copy
Snowflake
 SELECT *
FROM
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE
    CREATED = '2023-09-12 14:36:38.060'
    AND CONSTRAINT_TYPE = 'FOREIGN KEY';
Copy
The foreign keys that were created on the specified date and time.
Copy

警告

クエリが実行された時間によって作成日が特定される場合、クエリ結果が変わる可能性があります。オリジンデータベースで指定されたクエリを一度に実行し、新しいSnowflakeクエリで別の時間にオブジェクトを実行することが可能です。

9.選択列単一名ケース

SQL Server
 SELECT name
FROM sys.foreign_keys;
Copy

name

FK_Name_Test
Snowflake
 SELECT
    CONSTRAINT_NAME
FROM
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE
    CONSTRAINT_TYPE = 'FOREIGN KEY';
Copy

CONSTRAINT_NAME

FK_Name_Test

10.選択列修飾名ケース

SQL Server
 SELECT
    fk.name
FROM sys.foreign_keys AS fk;
Copy

name

FK_Name_Test
Snowflake
 SELECT
    fk.CONSTRAINT_NAME
FROM
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS fk
WHERE
    CONSTRAINT_TYPE = 'FOREIGN KEY';
Copy

CONSTRAINT_NAME

FK_Name_Test

既知の問題

1.制約にユーザーが作成した名前がない場合、「name」列は正しい出力を示さないことがあります

もし参照された名前がデータベースから自動生成されたものであれば、それを見直して希望の値を使用することができるでしょう。

2.列を選択する場合、Snowflakeで同等の適用可能な列に応じて制限があります

sys.foreign_keysの列はSnowflakeでは完全に等価ではないため、等価性の制限により結果が変わる場合があります。

3.OBJECT_ID()関数が処理すべき有効なパターンを持っているか、データベース、スキーマ、またはテーブルを抽出できませんでした

OBJECT_ID()関数を受け取った名前に基づいて、この名前の処理は制限され、形式に依存します。

4.OBJECT_NAME()関数ケースを使用した名前列

OBJECT_NAME()関数はまだサポートされていないため、この関数に関連する変換はサポートされていません。

 SELECT name AS ForeignKeyName,
       OBJECT_NAME(parent_object_id) AS ReferencingTable,
       OBJECT_NAME(referenced_object_id) AS ReferencedTable
FROM sys.foreign_keys;
Copy
 SELECT
    name AS ForeignKeyName,
    !!!RESOLVE EWI!!! /*** SSC-EWI-0073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'OBJECT_NAME' NODE ***/!!!
    OBJECT_NAME(parent_object_id) AS ReferencingTable,
    !!!RESOLVE EWI!!! /*** SSC-EWI-0073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'OBJECT_NAME' NODE ***/!!!
    OBJECT_NAME(referenced_object_id) AS ReferencedTable
FROM
    INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE
    CONSTRAINT_TYPE = 'FOREIGN KEY';
Copy
5.SCHEMA_NAME()と TYPE_NAME()関数もまだサポートされていません。
6.システムテーブルがサポートされていない場合、異なる結合ステートメント型がサポートされないことがあります。
7.JOIN ステートメントを含むケースはサポートされていません。
8.エイリアス AS を含む名前はサポートされていません。

関連 EWIs

  1. SSC-EWI-0073: 機能同等性レビュー保留中。

言語: 日本語