CREATE and ALTER Indexes in MSSQL 2000

• kpresario

  SSC Rookie

  Points: 40

  More actions

  June 27, 2011 at 7:51 pm

  #238503

  I have to use MS SQL2000 server. I have problem to use the following script to customize the indexes options in SQL 2000. Also the ALTER INDEX is not support in MS SQL2000 as well.

  Can you enlightened me how to do it MS SQL2000? The following is the script in MS SQL2008 style.

  CREATE TABLE [dbo].[Categories](

  [CategoryID] [int] IDENTITY(1,1) NOT NULL,

  [CategoryName] [nvarchar](15) NOT NULL,

  [Description] [ntext] NULL,

  [Picture] [image] NULL,

  CONSTRAINT [PK_Categories] PRIMARY KEY CLUSTERED

  (

  [CategoryID] ASC

  )WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR=80) ON [PRIMARY]

  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

  GO

  Thank you in advanced.

• C a z

  Valued Member

  Points: 74

  More actions

  June 27, 2011 at 9:52 pm

  #1344940

  Creating an index is pretty easy.

  CREATE INDEX index_name

  ON table_name (field_to_index)

  Is this what you were looking for?

  Caz

• kpresario

  SSC Rookie

  Points: 40

  More actions

  June 27, 2011 at 11:05 pm

  #1344951

  Your script can't set the PAD_INDEX and FILLFACTOR value. I am looking for the script able to do it in MSSQL 2000.

  Looking for method like CREATE and ALTER those indexes option.