SQLServer 筑表 SQL 基础

USE dbTestGO/*******************************************************DataServer: localhost*DataBase:   dbTest*Name:       Test_SQL_Table*Function:   Test_SQL_Table *Input:	 *Output:	*Creator:    greatwqs 2012-02-23*Updated: ******************************************************/CREATE TABLE [dbo].[Test_SQL_Table](        -- IDENTITY(1,1) 从1自动增长1	[id]          [int]       IDENTITY(1,1) NOT NULL,	[websiteID]   [int]       NULL,	[visitIP]     [char](15)  NOT NULL,	[visitTime]   [datetime]  NOT NULL,	[visitStatus] [int]       NULL,	[createTime]  [datetime]  NULL      DEFAULT (getdate()),-- id为主键 CONSTRAINT [PK_Test_SQL_Table] PRIMARY KEY CLUSTERED (	[id] ASC) ON [PRIMARY]) ON [PRIMARY]GO-- 外键创建索引CREATE NONCLUSTERED INDEX [IX_Test_SQL_Table_websiteID]  ON [dbo].[Test_SQL_Table] (	[websiteID] ASC) WITH (FILLFACTOR = 90) ON [PRIMARY]GO

?

建表SQL实例, 自动增长, 默认值, 主键, 外键 外键在这里创建索引里面的websiteID为外键.

?