Comparing CREATE TABLE Syntax: MySQL vs. SQL Server

CREATE TABLE [ database_name . [ schema_name ] . | schema_name . ] table_name 
(
    column_name1 data_type [ NULL | NOT NULL ] 
        [ CONSTRAINT constraint_name DEFAULT constant_expression ] 
        [ IDENTITY [ ( seed , increment ) ] ]
        [ ROWGUIDCOL ] 
        [ CONSTRAINT constraint_name { PRIMARY KEY | UNIQUE } [ CLUSTERED | NONCLUSTERED ] ]
        [ CONSTRAINT constraint_name CHECK ( logical_expression ) ]
        [ CONSTRAINT constraint_name FOREIGN KEY REFERENCES referenced_table_name ( referenced_column_name ) 
            [ ON DELETE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ] 
            [ ON UPDATE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ] ]
        [ COLLATE collation_name ]
        [ SPARSE ]
        [ MASKED WITH ( FUNCTION = 'mask_function' ) ]
        [ ENCRYPTED WITH ( COLUMN_ENCRYPTION_KEY = key_name, ENCRYPTION_TYPE = { DETERMINISTIC | RANDOMIZED }, 
            ALGORITHM = 'AEAD_AES_256_CBC_HMAC_SHA_256' ) ]
        [ GENERATED ALWAYS AS { ROW | TRANSACTION_ID | SEQUENCE_NUMBER } [ START | END ] [ HIDDEN ] ]
        [ GENERATED ALWAYS AS ( computed_column_expression ) [ PERSISTED [ NOT NULL ] ] ]
    [ ,...n ]

    [ CONSTRAINT constraint_name PRIMARY KEY [ CLUSTERED | NONCLUSTERED ] 
        ( column [ ASC | DESC ] [ ,...n ] ) 
        [ WITH ( <index_option> [ ,...n ] ) ]
    ]

    [ CONSTRAINT constraint_name UNIQUE [ CLUSTERED | NONCLUSTERED ] 
        ( column [ ASC | DESC ] [ ,...n ] ) 
        [ WITH ( <index_option> [ ,...n ] ) ]
    ]

    [ CONSTRAINT constraint_name FOREIGN KEY ( column [ ,...n ] ) 
        REFERENCES referenced_table_name ( referenced_column_name [ ,...n ] ) 
        [ ON DELETE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ] 
        [ ON UPDATE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ] 
    ]

    [ CONSTRAINT constraint_name CHECK ( logical_expression ) ]

    [ PERIOD FOR SYSTEM_TIME ( system_start_time_column_name, system_end_time_column_name ) ]
)
[ WITH ( <table_option> [ ,...n ] ) ]
[ ON { partition_scheme_name ( partition_column_name ) | filegroup | "default" } ]
[ TEXTIMAGE_ON { filegroup | "default" } ]
[ FILESTREAM_ON { partition_scheme_name | filegroup | "default" } ]
[ PARTITION ( column_name RANGE [ LEFT | RIGHT ] FOR VALUES ( [ boundary_value [ ,...n ] ] ) ) ];

CREATE TABLE Production.Products (
    ProductID INT NOT NULL IDENTITY(1001, 1),
    ProductName NVARCHAR(255) NOT NULL,
    ProductCode NVARCHAR(50) NOT NULL,
    CategoryID INT NOT NULL,
    SupplierID INT NULL,
    Price DECIMAL(10, 2) NOT NULL CONSTRAINT DF_Products_Price DEFAULT 0.00,
    Cost DECIMAL(10, 2) NULL,
    StockQuantity INT NOT NULL CONSTRAINT DF_Products_StockQuantity DEFAULT 0,
    ReorderLevel INT NULL CONSTRAINT DF_Products_ReorderLevel DEFAULT 5,
    Weight FLOAT NULL,
    Dimensions NVARCHAR(50) NULL,
    ShortDescription NVARCHAR(255) NULL,
    LongDescription NVARCHAR(MAX) NULL,
    IsFeatured BIT CONSTRAINT DF_Products_IsFeatured DEFAULT 0,
    IsActive BIT CONSTRAINT DF_Products_IsActive DEFAULT 1,
    DateAdded DATETIME2 CONSTRAINT DF_Products_DateAdded DEFAULT GETDATE(),
    LastUpdated DATETIME2 NULL,
    
    CONSTRAINT PK_Products PRIMARY KEY CLUSTERED (ProductID),
    CONSTRAINT UQ_Products_ProductCode UNIQUE NONCLUSTERED (ProductCode),
    
    CONSTRAINT FK_Products_Categories FOREIGN KEY (CategoryID) 
        REFERENCES Production.Categories (CategoryID) 
        ON UPDATE CASCADE 
        ON DELETE RESTRICT,
        
    CONSTRAINT FK_Products_Suppliers FOREIGN KEY (SupplierID) 
        REFERENCES Production.Suppliers (SupplierID) 
        ON UPDATE CASCADE 
        ON DELETE SET NULL,
        
    CONSTRAINT CK_Products_Price CHECK (Price >= 0),
    CONSTRAINT CK_Products_StockQuantity CHECK (StockQuantity >= 0)
)
WITH (
    DATA_COMPRESSION = PAGE,
    DURABILITY = SCHEMA_AND_DATA
)
ON ProductsFileGroup
TEXTIMAGE_ON LargeDataFileGroup;

-- Create indexes
CREATE NONCLUSTERED INDEX IX_Products_CategoryID ON Production.Products (CategoryID);
CREATE NONCLUSTERED INDEX IX_Products_SupplierID ON Production.Products (SupplierID) WHERE SupplierID IS NOT NULL;
CREATE NONCLUSTERED INDEX IX_Products_ProductName ON Production.Products (ProductName);

-- Create a full-text index
CREATE FULLTEXT INDEX ON Production.Products (ProductName, ShortDescription) 
KEY INDEX PK_Products
ON ProductCatalogFullTextIndex
WITH CHANGE_TRACKING AUTO;