SA0066B : Check all Columns for following specified naming convention

 1ALTER TABLE Persons
 2ADD CONSTRAINT PK_Person PRIMARY KEY (ID,LastName),
 3 DateOfBirth datetime
 4
 5ALTER TABLE Persons
 6ADD CONSTRAINT PK_Person PRIMARY KEY (ID);
 7
 8ALTER TABLE Persons
 9ADD FOREIGN KEY (OrderId) REFERENCES Orders(Id);
10
11ALTER TABLE Persons
12ADD CONSTRAINT FK_OrderPerson FOREIGN KEY (OrderId) REFERENCES Orders(Id);
13
14ALTER TABLE Persons
15ADD DateOfBirth datetime;
16
17ALTER TABLE Persons 
18ADD Gender bit NOT NULL CONSTRAINT [Df_Gender] DEFAULT 0
19
20ALTER TABLE Persons
21ADD CONSTRAINT PK_Person PRIMARY KEY (ID,LastName1),
22FOREIGN KEY (FirstName,LastName) REFERENCES Persons(FirstName,LastName);
23
24ALTER TABLE Persons
25ALTER COLUMN Position nchar;
26
27ALTER TABLE Persons
28ALTER COLUMN DateOfBirth year;
29
30ALTER TABLE Persons
31ALTER COLUMN Salary money;
32
33CREATE TABLE Persons (
34    Id int NOT NULL,
35    OrderId int,
36    FOREIGN KEY (OrderId) REFERENCES Orders(Id),
37    PRIMARY KEY (Id)
38)
39
40CREATE TABLE Persons (
41    ID int NOT NULL IDENTITY (1,1) PRIMARY KEY,
42    OrderId int FOREIGN KEY REFERENCES Orders(Id),
43    LastName varchar(255) NOT NULL,
44    MiddleName ntext,
45    FirstName nvarchar(255),
46    Position char,
47    Remark text,
48    Age smallint,
49    Salary numeric
50);
51
52CREATE TABLE Persons (
53    Id int NOT NULL,
54    OrderId int,
55    LastName varchar(255) NOT NULL,
56    CONSTRAINT FK_PersonOrder FOREIGN KEY (OrderId) REFERENCES Orders(Id),
57    CONSTRAINT PK_Person PRIMARY KEY (Id,LastName)
58)
59
60ALTER TABLE Persons
61ADD PRIMARY KEY (ID);
62
63ALTER TABLE Persons
64DROP COLUMN DateOfBirth;
65
66INSERT INTO Persons (Remark) 
67SELECT 'Hello!'
68UNION ALL 
69SELECT 'Hi!'
70UNION ALL
71SELECT 'Hello, world!'
72
73INSERT INTO Persons (Remark) 
74VALUES ('How do yo do?'),
75        ('Good morning!'),
76        ('Good night!')
77
78DELETE  Persons WHERE Id = 3
79
80SELECT * FROM Persons p 
81WHERE p.Remark like 'Hello%'
82
83DROP TABLE Persons