# "ListCategories" Stored Procedure

Description:

This stored procedure returns all category information from the Categories table, based on a project id.

Definition:

    	CREATE PROCEDURE TT_ListCategories
    	(
    		@ProjectID int
    	)
    	AS

    	SELECT
    		CategoryID, Name, Abbreviation, EstDuration

    	FROM
    		TT_Categories

    	WHERE
    		ProjectID = @ProjectID

Database Tables Used:

The primary key in the Categories table is the CategoryID identity field.