Creacion de tablas con valores predeterminados e indices
CREATE TABLE dbo.status_tabla
(
id int NOT NULL,
status_tabla nvarchar(50) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE dbo.status_tabla ADD CONSTRAINT
PK_status_tabla PRIMARY KEY CLUSTERED
(
id
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX IX_status_tabla ON dbo.status_tabla
(
status_tabla
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO