[dbo].[keys]
(local)
>
mdb
>
Tables
> dbo.keys
Properties
Columns
Indexes
SQL Script
Uses
Properties
Property
Value
Row Count
0
Created
12:31:04 PM Sunday, December 05, 2010
Last Modified
12:31:04 PM Sunday, December 05, 2010
Columns
Name
Data Type
Max Length (Bytes)
Allow Nulls
keyid
int
4
newkey
int
4
Indexes
Name
Columns
Unique
XPKkeys
keyid
SQL Script
CREATE
TABLE
[dbo]
.
[keys]
(
[keyid]
[int]
NOT
NULL
,
[newkey]
[int]
NOT
NULL
)
ON
[PRIMARY]
GO
ALTER
TABLE
[dbo]
.
[keys]
ADD
CONSTRAINT
[XPKkeys]
PRIMARY
KEY
CLUSTERED
(
[keyid]
)
ON
[PRIMARY]
GO
Uses
dbo