Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create database EmpresaVinil;
- use EmpresaVinil;
- Drop table Discos;
- Create table Discos (IdDisco INT Identity(1,1) Primary Key , TituloDaObra varchar(60) NOT NULL,Interprete varchar(60) NOT NULL,
- Genero varchar(30) NOT NULL,Editora varchar(30) NOT NULL, AnoDeEdicao INT NOT NULL,Nacionalidade varchar(40) NOT NULL,);
- exec sp_rename 'Discos.Genero' , 'GeneroMusical';
- aLTER table Discos add PrecoDeVenda money NOT NULL;
- INSERT INTO Discos VALUES ('Bethooven', 'Afonso', 'Rock/Funk', 'UDR PRODUCTION' , 1990, 'Brasileiro', 420);
- SELECT * FROM Discos;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement