Object Type	Table
Datasource	IPMA
Database	publications

Columns

Name	Datatype	Null

code	char(19)	No

author	char(32)	No

author_number	int	Yes

Table Usage (MB)

Distribution of Table Space

Data	0.53	Data	49.28 %
Indexes	0.49	Indexes	45.83 %
Unused	0.05	Unused	4.89 %
Total	1.08	Number of Rows	7949

Dependencies

Referencing Objects

Object Name Object Type

dbo.add_author PROCEDURE

dbo.delete_all_authors PROCEDURE

dbo.delete_publication PROCEDURE

dbo.authors.authors_ux INDEX

Referenced Objects

Object Name Object Type

DDL

CREATE TABLE dbo.authors 
(
    code          char(19) NOT NULL,
    author        char(32) NOT NULL,
    author_number int      NULL
)
LOCK ALLPAGES
go

Object Name	Object Type
dbo.add_author	PROCEDURE
dbo.delete_all_authors	PROCEDURE
dbo.delete_publication	PROCEDURE
dbo.authors.authors_ux	INDEX