dbo.members

 

Object Type

Table

Datasource

IPMA

Database

controls

 

Columns
Name Datatype Null
name varchar(8) No
id numeric(5,0) No
extra1 varchar(32) Yes
extra2 varchar(32) Yes

Table Usage (MB)

Distribution of Table Space

 

Data

0.08

Data

26.32 %

Indexes

0.10

Indexes

34.21 %

Unused

0.12

Unused

39.47 %

Total

0.30

Number of Rows

2927

Dependencies
Referencing Objects
Object Name Object Type
dbo.registeruser_sp PROCEDURE
dbo.members.members_ux INDEX
Referenced Objects
Object Name Object Type

DDL

CREATE TABLE dbo.members 
(
    name   varchar(8)   NOT NULL,
    id     numeric(5,0) NOT NULL,
    extra1 varchar(32)  NULL,
    extra2 varchar(32)  NULL
)
LOCK ALLPAGES
go