如何使用正确的对象顺序编写MS SQL Server数据库脚本？

-- 创建数据库
CREATE DATABASE MyDatabase;

-- 创建文件组
CREATE FILEGROUP MyFileGroup
    CONTAINS FILESTREAM;

-- 创建文件
CREATE FILE (NAME='MyFile', FILENAME='C:\MyDatabase\MyFile.ndf')
    ON FILEGROUP MyFileGroup;

-- 创建表
CREATE TABLE MyTable (
    ID INT PRIMARY KEY,
    Name NVARCHAR(50),
    FileData VARBINARY(MAX) FILESTREAM
);

-- 创建索引
CREATE INDEX MyIndex ON MyTable (ID);

-- 创建视图
CREATE VIEW MyView AS
SELECT ID, Name
FROM MyTable;

-- 创建存储过程
CREATE PROCEDURE MyProcedure
AS
BEGIN
    SELECT * FROM MyTable;
END;

-- 创建函数
CREATE FUNCTION MyFunction
RETURNS INT
AS
BEGIN
    DECLARE @Count INT;
    SELECT @Count = COUNT(*) FROM MyTable;
    RETURN @Count;
END;

-- 创建触发器
CREATE TRIGGER MyTrigger
ON MyTable
AFTER INSERT
AS
BEGIN
    PRINT 'A new record has been inserted.';
END;

-- 创建约束
ALTER TABLE MyTable
ADD CONSTRAINT MyConstraint
CHECK (ID > 0);