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( […]