| Home |
| Articles |
| Backup |
| Books |
| Certification |
| FAQ |
| Products |
| Replication |
| Scripts |
| Seminars |
| Training |
| TSQL |
|
| MSDN Fourms |
| Philippine SSUG |
| Fort Worth SSUG |
| Oklahoma City SSDG |
|
| Resume |
|
| MHS Enterprises |
| BlowFrog Software |
| FilAm Software |
| AcrylicAcetate.com |
| Bargain Humidors |
| Western Humidor |
|
|
RapidSQL 5.2 1 2 3 4 5 6 7 8 9 10
| Object
Type |
Table |
| Datasource |
HOTEKBDC ( SQL Server 7.00.623 ) |
| Login |
sa |
| Report
Date |
11/04/1999 07:01:05PM |
| Name |
Datatype |
Null |
Default |
Default Binding |
Rule Binding |
| au_id |
id |
No |
|
|
|
| au_lname |
varchar(40) |
No |
|
|
|
| au_fname |
varchar(20) |
No |
|
|
|
| phone |
char(12) |
No |
'UNKNOWN' |
|
|
| address |
varchar(40) |
Yes |
|
|
|
| city |
varchar(20) |
Yes |
|
|
|
| state |
char(2) |
Yes |
|
|
|
| zip |
char(5) |
Yes |
|
|
|
| contract |
bit |
No |
|
|
|
| Name |
Type |
Constraint |
| UPKCL_auidind |
PRIMARY KEY |
au_id |
| CK__authors__au_id__08EA5793 |
Check |
([au_id] like
'[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]') |
| CK__authors__zip__0AD2A005 |
Check |
([zip] like '[0-9][0-9][0-9][0-9][0-9]') |
| File
Group |
PRIMARY |
Text
Image File Group |
PRIMARY |
| Number
of Rows |
23 |
| Table Usage
(MB) |
Distribution
of Table Space |
| Data |
0.01 |
Data |
16.67 % |
| Indexes |
0.04 |
Indexes |
83.33 % |
| Unused |
0.00 |
Unused |
0.00 % |
| Total |
0.05 |
|
|
| Object Name |
Object Type |
| dbo.titleview |
VIEW |
| dbo.reptq2 |
PROCEDURE |
| dbo.titleauthor |
TABLE |
| dbo.authors.aunmind |
INDEX |
| Object Name |
Object Type |
| dbo.id |
USER DEFINED DATATYPE |
|
| Object Name |
Delete |
Execute |
Insert |
References |
Select |
Update |
| guest |
Y |
|
Y |
Y |
Y |
Y |
IF OBJECT_ID('dbo.authors') IS NOT NULL
BEGIN
DROP TABLE dbo.authors
IF OBJECT_ID('dbo.authors') IS NOT NULL
PRINT '<<< FAILED DROPPING TABLE dbo.authors>>>'
ELSE
PRINT '<<< DROPPED TABLE dbo.authors>>>'
END
go
CREATE TABLE dbo.authors
(
au_id id NOT NULL,
au_lname varchar(40) NOT NULL,
au_fname varchar(20) NOT NULL,
phone char(12) DEFAULT 'UNKNOWN' NOT NULL,
address varchar(40) NULL,
city varchar(20) NULL,
state char(2) NULL,
zip char(5) NULL,
contract bit NOT NULL,
CONSTRAINT UPKCL_auidind PRIMARY KEY CLUSTERED (au_id),
CONSTRAINT CK__authors__au_id__08EA5793 CHECK ([au_id] like '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]'),
CONSTRAINT CK__authors__zip__0AD2A005 CHECK ([zip] like '[0-9][0-9][0-9][0-9][0-9]')
)
go
IF OBJECT_ID('dbo.authors') IS NOT NULL
PRINT '<<< CREATED TABLE dbo.authors>>>'
ELSE
PRINT '<<< FAILED CREATING TABLE dbo.authors>>>'
go
|
