[dbo].[keys]
(local)
>
mdb
>
Tables
> dbo.keys
Properties
Columns
Indexes
SQL Script
Uses
Properties
Property
Value
Row Count
0
Created
11:07:20 AM Wednesday, March 07, 2007
Last Modified
11:09:10 AM Wednesday, March 07, 2007
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