求助!我用sql语句建表,但是不会把字段的默认值用sql语句表示出来,望高手指点!
求助!我用sql语句建表,但是不会把字段的默认值用sql语句表示出来,望高手指点!
CREATE TABLE [Products] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[ProductID] [varchar] (50) NULL ,
[ProductName] [varchar] (50) NULL ,
[eProcuctName] [varchar] (100) NULL ,
[Description] [varchar] (255) NULL ,
[eDescription] [varchar] (255) NULL ,
[FOB] [varchar] (50) NULL ,
[Packing] [varchar] (100) NULL ,
[ePacking] [varchar] (100) NULL ,
[Origin] [varchar] (50) NULL ,
[eOrigin] [varchar] (50) NULL ,
[Country] [varchar] (50) NULL ,
[eCountry] [varchar] (50) NULL ,
[Email] [varchar] (50) NULL ,
[Contact] [varchar] (50) NULL ,
[eContact] [varchar] (50) NULL ,
[Telephone] [varchar] (50) NULL ,
[Fax] [varchar] (50) NULL ,
[Speciality] [varchar] (150) NULL ,
[eSpeciality] [varchar] (150) NULL ,
[URL] [varchar] (100) NULL ,
[Company] [varchar] (50) NULL ,
[eCompany] [varchar] (50) NULL ,
[Department] [varchar] (50) NULL ,
[eDepartment] [varchar] (50) NULL ,
[Address] [varchar] (100) NULL ,
[eAddress] [varchar] (100) NULL ,
[Picurl] [varchar] (5) NULL ,
[PicName] [varchar] (25) NULL ,
[Pic] AS ([Picurl] + [PicName]) ,
[InputDay] [datetime] NULL
) ON [PRIMARY]
GO