Plantillas Crear Tabla.

Este es una plantilla para crear una tabla.

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[TableName]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
 DROP TABLE [dbo].[TableName]
GO

CREATE TABLE [dbo].[TableName] (
 ColName1  DATETIME  NOT NULL,
 ColName2  INT   NOT NULL,
 ColName3  VARCHAR(12)  NOT NULL,
 ColName4 NUMERIC(12,0)  )
GO

ALTER TABLE [dbo].[TableName]
 ADD CONSTRAINT   PK_TableName
 PRIMARY KEY  (ColName1, ColName2, ColName3)
GO

GRANT ALL
 ON [dbo].[TableName]
 TO PUBLIC

Advertisement