Here is a sample of a customised template. There is a type of service table I use whose basic structure is pretty similar. I just delete the bits I don't need. It is far quicker than doing it by point 'n shoot.

[font="Courier New"]-- =========================================

-- Create table template

-- =========================================

USE <DATABASE, SYSNAME, MyDatabase>

GO

IF OBJECT_ID('<schema_name, sysname, dbo>.<table_name, sysname, sample_table>', 'U') IS NOT NULL

  DROP TABLE <schema_name, SYSNAME, dbo>.<table_name, SYSNAME, sample_table>

GO

CREATE TABLE <schema_name, SYSNAME, dbo>.<table_name, SYSNAME, sample_table>

(

   [<table_name, sysname, sample_table>_id] [int] IDENTITY(1,1) NOT NULL,

   [creator] [varchar](80) NOT NULL CONSTRAINT [DF_<table_name, sysname, sample_table>_creator]  DEFAULT (USER_NAME()),

   [insertiondate] [datetime] NOT NULL CONSTRAINT [DF_<table_name, sysname, sample_table>_insertiondate]  DEFAULT (GETDATE()),

   [terminationdate] [datetime] NULL

    CONSTRAINT PK_<schema_name, SYSNAME, dbo>_<table_name, SYSNAME, sample_table> PRIMARY KEY (<table_name, SYSNAME, sample_table>_id)

)

GO

-- Add description to table object

EXEC sys.sp_addextendedproperty

   @name=N'MS_Description',

   @value=N'<table_description_value,,Table description here>' ,

   @level0type=N'SCHEMA',

   @level0name=N'<schema_name, sysname, dbo>',

   @level1type=N'TABLE',

   @level1name=N'<table_name, sysname, sample_table>'

GO

-- Add description to a specific column

EXEC sys.sp_addextendedproperty

   @name=N'MS_Description',

   @value=N'primary key for the table' ,

   @level0type=N'SCHEMA',

   @level0name=N'<schema_name, sysname, dbo>',

   @level1type=N'TABLE',

   @level1name=N'<table_name, sysname, sample_table>',

   @level2type=N'COLUMN',

   @level2name=N'<table_name, sysname, sample_table>_id'

GO

EXEC sys.sp_addextendedproperty

   @name=N'MS_Description',

   @value=N'Date the record was created (automatic)' ,

   @level0type=N'SCHEMA',

   @level0name=N'<schema_name, sysname, dbo>',

   @level1type=N'TABLE',

   @level1name=N'<table_name, sysname, sample_table>',

   @level2type=N'COLUMN',

   @level2name=N'insertiondate'

GO

EXEC sys.sp_addextendedproperty

   @name=N'MS_Description',

   @value=N'Date for the termination of the record' ,

   @level0type=N'SCHEMA',

   @level0name=N'<schema_name, sysname, dbo>',

   @level1type=N'TABLE',

   @level1name=N'<table_name, sysname, sample_table>',

   @level2type=N'COLUMN',

   @level2name=N'Terminationdate'

GO

EXEC sys.sp_addextendedproperty

   @name=N'MS_Description',

   @value=N'Creator of the record' ,

   @level0type=N'SCHEMA',

   @level0name=N'<schema_name, sysname, dbo>',

   @level1type=N'TABLE',

   @level1name=N'<table_name, sysname, sample_table>',

   @level2type=N'COLUMN',

   @level2name=N'creator'

GO

[/font]