Create Database emp and Then Execute the tables USE [emp] GO /****** Object: Table [dbo].[empdetails] Script Date: 12/27/2011 10:30:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[empdetails]( [empno] [int] IDENTITY(1,1) NOT NULL, [empname] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [empcode] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [department] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [salary] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [gender] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [skill] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [project] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF USE [emp] GO /****** Object: Table [dbo].[department] Script Date: 12/27/2011 10:29:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[department]( [department] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF USE [emp] GO /****** Object: Table [dbo].[projects] Script Date: 12/27/2011 10:30:27 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[projects]( [projectname] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF
No comments:
Post a Comment