11 lines
298 B
Bash
11 lines
298 B
Bash
sqlcmd -S localhost -U sa -P '<123123Aa!@>'
|
|
|
|
CREATE DATABASE MyDb;
|
|
go
|
|
|
|
USE MyDb;
|
|
go
|
|
CREATE TABLE t_class (id INT PRIMARY KEY, name VARCHAR(22));
|
|
go
|
|
CREATE TABLE t_student (id INT PRIMARY KEY, name VARCHAR(22), classId INT ,CONSTRAINT fk_stu_class1 FOREIGN KEY (classId) REFERENCES t_class(id));
|
|
go |