How to view the store procedure table schema and how to modify store procedure table parameters

Jul 16 2012 3:22 PM
Hello friends
        Below is my table

create

procedure studenttable

as

create

table studenttable(Stud_regno int ,Stud_id int primary key,Stud_name varchar(50),Dob date,gender varchar(20),father_name varchar(50),mother_name varchar(50),father_occupation varchar(40),mother_occupation varchar(40),contact_no bigint,email_id varchar(200),street varchar(250),city varchar(50),state varchar(100), country varchar(50),zipcode bigint);

From this table i want  to view the table structure and how to modify any of the  parametes
                                        please help me
                                            thank you all

Answers (2)