CREATE TABLE [Production].[Culture](
	[CultureID] [nchar](6) NOT NULL,
	[Name] [dbo].[Name] NOT NULL,
	[ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_Culture_ModifiedDate]  DEFAULT (getdate()),
 CONSTRAINT [PK_Culture_CultureID] PRIMARY KEY CLUSTERED 
(
	[CultureID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

quote:

---

Originally posted by kkrishna

Hi All,

I am trying to create a copy of the existing table Production.Culture in AdventureWorks database. I have the following code:

USE AdventureWorks;
CREATE TABLE Production.CultureNew
( CultureID(PK,nchar(6),not null)
Name(Name(nvarchar(50)),not null)
ModifiedDate(datetime,not null)
);

The column spec is exactly a copy of the columns in Production.Culture.
When I execute this query, I am getting the error message:

Msg 173, Level 15, State 1, Line 3
The definition for column 'CultureID' must include a data type.

I specified the data type as nchar(6). Why is this error generated?
What should I do further for the data type?

---

 SELECT *
   INTO Production.CultureNew
   FROM Production.Culture
  WHERE 1 = 0 --Comment this row out if you want the data, too!

  ALTER TABLE Production.CultureNew
    ADD PRIMARY KEY CLUSTERED (CultureID)