CREATE TABLE tb50019 (
codigo INT PRIMARY KEY,
nome varchar(30),
dataNasc date);
SELECT * FROM dbo.tb50019

ALTER TABLE dbo.tb50019
	ADD sobrenome VARCHAR(30);

ALTER TABLE dbo.tb50019
	ADD sexo CHAR(1);

ALTER TABLE dbo.tb50019
	ADD CONSTRAINT verificaSexo
	CHECK(sexo IN ('M', 'F'));

	INSERT INTO dbo.tb50019
		VALUES(1,'Guilherme','1990-09-14','M','Alexandre');

sp_help dbo.tb50019

ALTER TABLE dbo.tb50019
	DROP COLUMN sobrenome;
SELECT * FROM dbo.tb50019;
DROP TABLE dbo.tb50019;