12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849 |
- use [ddf]
- go
- set ansi_nulls on
- go
- set quoted_identifier on
- go
- set ansi_padding on
- go
- if not exists(select * from dbo.sysobjects where id = object_id(N'BranchInfo') and objectproperty(id,'IsTable') = 1)
- begin
- create table [dbo].[BranchInfo](
- [id] [int] identity(1,1) not null,
- [branch] [nvarchar](16) not null,
- [domain] [nvarchar](32) not null,
- [publicIP] [nvarchar](40) not null,
-
-
- constraint [PK_BranchInfo_id] primary key clustered
- (
- [id] asc
- ) with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off,allow_row_locks = on,allow_page_locks = on) on [primary],
-
- constraint [PK_BranchInfo_u] unique nonclustered
- (
- [domain] asc
- ) with (pad_index = off, statistics_norecompute = off, ignore_dup_key = off,allow_row_locks = on,allow_page_locks = on) on [primary]
- ) on [primary]
- end
- go
- set ansi_padding off
|