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

baskaran chellasamy

14y2.8k

Hello friends
Below is my table

create

procedure studenttable

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Senthilkumar14y ago
You can use the SP_HELP Table_Name to see the table schema.

You can add, drop and modify the columns in the sql server table.

To add a column in a table, use the following syntax:

ALTER TABLE table_name
ADD column_name datatype
To delete a column in a table, use the following syntax (notice that some database systems don't allow deleting a column):

ALTER TABLE table_name
DROP COLUMN column_name
To change the data type of a column in a table, use the following syntax:

Modify the column in the table,
ALTER TABLE table_name
ALTER COLUMN column_name datatype
14y ago
To get the table schema, EXEC sp_help studenttable.
Currenly in your sp, you don't have any parameters.
Please post more information.