Eu prefer să scriu codul pentru CREATE TABLE de mână, pentru că opţiunea "Generate Script" scrie mult cod inutil. De exemplu, să comparăm următorul script:
CREATE TABLE Salariati
(
ID int IDENTITY CONSTRAINT PK_Salariati PRIMARY KEY,
Nume varchar(25) NOT NULL,
Prenume varchar(25) NOT NULL,
Sex char(1) NOT NULL CONSTRAINT
CK_Salariati_Sex CHECK (Sex='M' OR Sex='F'),
ID_Sef int CONSTRAINT
FK_Salariati REFERENCES Salariati (ID)
)
Cu cel
generat de Management Studio:
USE
[tempdb]
GO
/******
Object: Table [dbo].[Salariati] Script Date: 05/14/2008 22:17:09
******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Salariati](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Nume] [varchar](25) NOT NULL,
[Prenume]
[varchar](25)
NOT NULL,
[Sex] [char](1) NOT NULL,
[ID_Sef] [int] NULL,
CONSTRAINT [PK_Salariati] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH
(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY
= OFF, ALLOW_ROW_LOCKS
= ON, ALLOW_PAGE_LOCKS
= ON) ON
[PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Salariati] WITH
CHECK ADD
CONSTRAINT [FK_Salariati] FOREIGN KEY([ID_Sef])
REFERENCES [dbo].[Salariati] ([ID])
GO
ALTER TABLE [dbo].[Salariati] CHECK
CONSTRAINT
[FK_Salariati]
GO
ALTER TABLE [dbo].[Salariati] WITH
CHECK ADD
CONSTRAINT [CK_Salariati_Sex] CHECK (([Sex] = 'M' or [Sex] = 'F'))
GO
ALTER TABLE [dbo].[Salariati] CHECK
CONSTRAINT
[CK_Salariati_Sex]
GO
Răzvan