CREATE TABLE fruit
(
  fruit_id INT IDENTITY(1,1)
      CONSTRAINT PK_fruit PRIMARY KEY CLUSTERED,
  fruit_name NVARCHAR(50),
  fruit_type INT
      CONSTRAINT FK_fruit_fruit_types FOREIGN KEY
      REFERENCES fruit_types (fruit_type_id) ON UPDATE CASCADE,
  date_created DATETIME DEFAULT CURRENT_TIMESTAMP
)

CREATE TABLE fruit
(
  fruit_id INT,
  fruit_name NVARCHAR(50),
  fruit_type_id INT,
  date_created DATETIME
)

ALTER TABLE fruit ALTER COLUMN fruit_id INT NOT NULL

ALTER TABLE fruit ADD
  CONSTRAINT PK_fruit PRIMARY KEY CLUSTERED (fruit_id),
  CONSTRAINT FK_fruit_fruit_types FOREIGN KEY (fruit_type_id)
      REFERENCES fruit_types (fruit_type_id),
  CONSTRAINT DF_fruit_date_created DEFAULT
      CURRENT_TIMESTAMP FOR date_created

IF NOT EXISTS (SELECT NULL FROM sys.schemas WHERE name = 's_name') BEGIN
    EXEC ('CREATE SCHEMA s_name')
END

IF EXISTS (SELECT NULL FROM sys.tables WHERE object_id = OBJECT_ID('s_name.t_name')) BEGIN
    DROP TABLE s_name.t_name
END

CREATE TABLE s_name.t_name
    (
        c_name        INT IDENTITY    NOT NULL
        , c_2_name    VARCHAR(10)   NULL            CONSTRAINT df_c_2_name DEFAULT ('def val')
        , CONSTRAINT pk_t_name_u_c                 PRIMARY KEY CLUSTERED (c_name) WITH (FILLFACTOR = 100)
        , CONSTRAINT ix_t_name_c_2_name_u_nc  UNIQUE NONCLUSTERED (c_2_name) WITH (FILLFACTOR = 100)
        , CONSTRAINT ck_t_name_c_2_name         CHECK (c_2_name IN('def val')) 
        , CONSTRAINT fk_t_name_t_2_name          FOREIGN KEY (c_2_name) REFERENCES s_name.t_2_name (c_2_name) --ON DELETE CASCADE
    )
GO