QrrNgqBG

1CREATE DATABASE universitatea;
2use universitatea
3GO
4IF NOT EXISTS(
5    SELECT *
6    FROM INFORMATION_SCHEMA.COLUMNS
7    WHERE TABLE_NAME = 'Grupe'
8)
9  BEGIN
10    CREATE TABLE [dbo].Grupe (
11      Id                       INT           NOT NULL IDENTITY (100, 1) PRIMARY KEY,
12      [Disciplina]             nvarchar(400) NOT NULL,
13      [Nr_ore_plan_disciplina] [int]         NULL,
14    )
15  END
16IF NOT EXISTS(
17    SELECT *
18    FROM INFORMATION_SCHEMA.COLUMNS
19    WHERE TABLE_NAME = 'Discipline'
20)
21  BEGIN
22    CREATE TABLE [dbo].Discipline (
23      Id               INT           NOT NULL IDENTITY (1, 1) PRIMARY KEY,
24      [Cod_Grupa]      nvarchar(100) NOT NULL,
25      [Specialitatea]  nvarchar(100) NOT NULL,
26      [Nume_Facultate] nvarchar(300) NOT NULL
27    )
28  END
29GO