-- =============================================
-- create table with rowguidcol column
-- =============================================
if exists (select TABLE_NAME 
           from INFORMATION_SCHEMA.TABLES
           where TABLE_NAME = N'TSTNewTable' 
             and TABLE_TYPE = N'BASE TABLE')
  DROP TABLE TSTNewTable
go

CREATE TABLE TSTNewTable 
(   TSTNewTable_guid  UNIQUEIDENTIFIER NOT NULL
        CONSTRAINT DfltTSTNewTableGUID DEFAULT newid(), 
    rowver            TIMESTAMP        NOT NULL,
    creatdate         DATETIME         NOT NULL
        CONSTRAINT DfltCreatDateTSTNewTable DEFAULT getdate(),
    creatuser         VARCHAR(128)     NOT NULL
        CONSTRAINT DfltCreatUserTSTNewTable DEFAULT suser_sname(),
    modifdate         DATETIME         NOT NULL
        CONSTRAINT DfltModifDateTSTNewTable DEFAULT getdate(),
    modifuser         VARCHAR(128)     NOT NULL
        CONSTRAINT DfltModifUserTSTNewTable DEFAULT suser_sname(),
    intColInteger     INTEGER          NOT NULL,

    CONSTRAINT PK_TSTNewTable PRIMARY KEY 
    NONCLUSTERED (TSTNewTable_guid)
)
ON [primary]

go