新建表的一些信息

CREATE TABLE TLog1
(
    FID BIGINT IDENTITY(1,1) PRIMARY KEY,
    FName VARCHAR(30) NOT NULL 
)
GO

 

 

CREATE TABLE TLog2
(
    FID BIGINT IDENTITY(1,1) NOT NULL,
    FName VARCHAR(30) NOT NULL 
)
GO


CREATE CLUSTERED INDEX PK_TLog2_FID
ON TLog2(FID)
GO

 

 

CREATE TABLE TLog3
(
    FID UNIQUEIDENTIFIER DEFAULT(NEWSEQUENTIALID()) PRIMARY KEY,
    FName VARCHAR(30) NOT NULL 
)
GO

 

 

CREATE TABLE TLog4
(
    FID UNIQUEIDENTIFIER DEFAULT(NEWSEQUENTIALID()) NOT NULL, 
    FName VARCHAR(30) NOT NULL
)
GO


CREATE CLUSTERED INDEX PK_TLog4_FID
ON TLog4(FID)
GO