CREATE TABLE [dbo].[TBSTATE] ( 
[STATETBLKEY]  INT                              NOT NULL,
[INDEXTBLKEY]  INT                              NOT NULL,
[STATECODE]    CHAR(2)                          NOT NULL,
[STATENAME]    VARCHAR(50)                      NOT NULL,
[FIPS]         CHAR(2)                              NULL,
CONSTRAINT   [PK__TBSTATE__17A421EC]                   PRIMARY KEY CLUSTERED    (STATETBLKEY),
CONSTRAINT   [STATECODEUNIQUE]                         UNIQUE      NONCLUSTERED (STATECODE))

GO

EXEC sys.sp_addextendedproperty 
         @name = N'FIPS', @value = N'the FIPS code is a two digit numeric-only varchar with preceeding zeros assigned by the government', 
         @level0type = N'SCHEMA', @level0name = [dbo], 
         @level1type = N'TABLE', @level1name = [TBSTATE];

create table blah(
blahid decimal(18,0) identity(1,1)  NOT FOR REPLICATION  primary key ,
blahname sysname)

select * from sys.columns where object_name(object_id)='blah'

exec sp_getddl blah

drop table blah