use master;
go
if DB_ID(N'lab_10') is not null
drop database lab_10;
go
create database lab_10
on (
NAME = lab_10dat,
FILENAME = 'C:\DB\lab_10\lab_10dat.mdf',
SIZE = 10,
MAXSIZE = UNLIMITED,
FILEGROWTH = 5
)
log on (
NAME = lab_10log,
FILENAME = 'C:\DB\lab_10\lab_10log.ldf',
SIZE = 5,
MAXSIZE = 20,
FILEGROWTH = 5
);
go

use lab_10;
go

if OBJECT_ID(N'Card',N'U') is NOT NULL
DROP TABLE Card;
go

CREATE TABLE Card(
Card_Id int PRIMARY KEY,
name char(30) NOT NULL,
surname char(30) NOT NULL,
number numeric(20) NOT NULL,
);
go

INSERT INTO Card(Card_Id,name, surname, number)
VALUES (1,N'Игорь', 'Неоновый гонщик', 12335532),
(2,N'Аристарх','Скоростной зверь', 139985532),
(3, N'Николай', 'Кровавый спорт', 98765567),
(4,N'Евгений', 'Африканская сетка', 7632567284)
go

SELECT * FROM Card;
go