City

This script creates a table named [JFW].[City] in the [JFW_live] database. The table has the following columns:

• [ID]: bigint, auto-incrementing primary key

• [Country_Code]: varchar(2), nullable

• [State_Code]: varchar(5), nullable

• [Name]: nvarchar(max), nullable

• [Modified_By]: bigint, nullable

• [Modified_Date]: datetime, not null

• [Created_By]: bigint, nullable

• [Created_Date]: datetime, not null

The table also has the following constraints:

• [PK_City]: primary key constraint on the [ID] column

• [DF_City_ModifiedDate]: default constraint to set [Modified_Date] to the current UTC date and time

• [DF_City_CreatedDate]: default constraint to set [Created_Date] to the current UTC date and time

This table is stored on the [PRIMARY] filegroup and uses the [PRIMARY] filegroup for text and image data.