Tuesday, December 9, 2014

Avanzado

Comandos mas avanzados.

Epoca de examenes D':

SELECT name
FROM sys.key_constraints
WHERE type = 'PK' AND OBJECT_NAME(parent_object_id) = N'Estudiantes';
ALTER TABLE dbo.Estudiantes
DROP CONSTRAINT PK__Estudiantes__7C8480AE
GO
ALTER TABLE dbo.Estudiantes
DROP COLUMN P_id
GO

No comments:

Post a Comment