Adding the primary key for two columns
CREATE TABLE Persons (
ID int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int,
CONSTRAINT PK_Person PRIMARY KEY (ID,LastName)
Index on view
Let's say if we create index on a view and if we alter the view then the index gets dropped and again we have to create a index on the view
Comments
Post a Comment