-- =============================================
-- create table with rowguidcol column
-- =============================================
if exists (select TABLE_NAME 
           from INFORMATION_SCHEMA.TABLES
           where TABLE_NAME = N'<table_name, sysname, TST_TestTable>' 
             and TABLE_TYPE = N'BASE TABLE')
  DROP TABLE <table_name, sysname, TST_TestTable>
go

CREATE TABLE <table_name, sysname, TST_TestTable> 
(   <table_name, sysname, TST_TestTable>GUID UNIQUEIDENTIFIER NOT NULL
        CONSTRAINT Dflt<table_name, sysname, TST_TestTable>GUID DEFAULT newid(), 
    rowver              TIMESTAMP    NOT NULL,
    creatdate           DATETIME     NOT NULL
        CONSTRAINT DfltCreatDate<table_name, sysname, TST_TestTable> DEFAULT getdate(),
    creatuser           VARCHAR(128) NOT NULL
        CONSTRAINT DfltCreatUser<table_name, sysname, TST_TestTable> DEFAULT suser_sname(),
    modifdate           DATETIME     NOT NULL
        CONSTRAINT DfltModifDate<table_name, sysname, TST_TestTable> DEFAULT getdate(),
    modifuser           VARCHAR(128) NOT NULL
        CONSTRAINT DfltModifUser<table_name, sysname, TST_TestTable> DEFAULT suser_sname(),
    <column, sysname, intCol2> <datatype_for_column, , INTEGER> NOT NULL,

    CONSTRAINT PK_<table_name, sysname, TST_TestTable> PRIMARY KEY 
    NONCLUSTERED (<table_name, sysname, TST_TestTable>_guid)
)
ON <file_group_name_1, , [primary]>

go