a guest Oct 14th, 2019 66 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create database EmpresaVinil;
  2. use EmpresaVinil;
  3. Drop table Discos;
  4. Create table Discos (IdDisco INT Identity(1,1) Primary Key , TituloDaObra varchar(60) NOT NULL,Interprete varchar(60) NOT NULL,
  5. Genero varchar(30) NOT NULL,Editora varchar(30) NOT NULL, AnoDeEdicao INT NOT NULL,Nacionalidade varchar(40) NOT NULL,);
  6. exec sp_rename 'Discos.Genero' , 'GeneroMusical';
  7. aLTER table Discos add PrecoDeVenda money NOT NULL;
  8. INSERT INTO Discos VALUES ('Bethooven', 'Afonso', 'Rock/Funk', 'UDR PRODUCTION' , 1990, 'Brasileiro', 420);
  9. SELECT * FROM Discos;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand