You can provide a user-friendly name at creation time by explicitly giving it a name.
Note that I have included the table name in the constarint name. This is because...

Since you want to drop all procs, views, and all but 2 tables, why not simply start with a new DB, and create the 2 tables.  Data from just 2...

The best that I can come up with is 

cast(case substring(@dtString, 20, 1)
    when '+' then dateadd(mi, -datediff(mi, 0, substring(@dtString, 21, 5)), substring(@dtString, 1, 19))

A couple of items to take note of
1 - Parameter @Message ... Why NVARCHAR - Your messages have no unicode characters.  Why MAX - Your messages are short enough for...

I cannot identify what you are looking for, but perhaps this will start you off along the right track.

DECLARE @data XML = N'<navigation>
<content label="Introduction">

Weekend

I would parse the xml, like this

declare @INQ table (
id int
, ordertxt varchar(3000)
)

insert into @INQ (id, ordertxt)
values