CREATE TABLE asurnet.dbo.COMPETIDORES (
	COM_ID int IDENTITY(1,1) NOT NULL,
	OPT_ID int NULL,
	COM_NOMBRE char(30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	COM_COMPANIA char(30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	COM_PRODUCTO char(30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	COM_COMENTARIOS char(60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	COM_PRECIO money NULL,
	CONSTRAINT PK_COMPETIDORES PRIMARY KEY (COM_ID)
) 
 CREATE NONCLUSTERED INDEX IND_COM_OPT_ID ON asurnet.dbo.COMPETIDORES (  OPT_ID ASC  )
	 WITH (  PAD_INDEX = OFF ,FILLFACTOR = 100  ,SORT_IN_TEMPDB = OFF , IGNORE_DUP_KEY = OFF , STATISTICS_NORECOMPUTE = OFF , ONLINE = OFF , ALLOW_ROW_LOCKS = ON , ALLOW_PAGE_LOCKS = ON  )
	 ON [PRIMARY ] ;