How to use SP_HELP and SP_COLUMNS Stored Procedures to View, Define and Describe the Structure of a Table in SQL Server
We can use the SP_HELP and SP_COLUMNS stored procedures define the structure of a Table in SQL-Server.
SP_COLUMNS :
This stored procedure returns column information for the specified objects that can be queried in the current environment.
Example :
SP_HELP:
Reports information about a database object (any object listed in the sysobjects table), a user-defined data type, or a data type supplied by Microsoft® SQL Server™.
Example :
CREATE TABLE ORDERS(OID INT NOT NULL,CNAME CHAR(15),
PRODUCT VARCHAR(15),P_COST DECIMAL(10,2));
The SP_HELP Procedure Describes the Table like this ...:
We can use the SP_HELP and SP_COLUMNS stored procedures define the structure of a Table in SQL-Server.
SP_COLUMNS :
This stored procedure returns column information for the specified objects that can be queried in the current environment.
Example :
CREATE TABLE ORDERS(OID INT NOT NULL,CNAME CHAR(15),
PRODUCT VARCHAR(15),P_COST DECIMAL(10,2));
The SP_COLUMNS Procedure Describes the Table like this ... :
PRODUCT VARCHAR(15),P_COST DECIMAL(10,2));
The SP_COLUMNS Procedure Describes the Table like this ... :
SP_HELP:
Reports information about a database object (any object listed in the sysobjects table), a user-defined data type, or a data type supplied by Microsoft® SQL Server™.
Example :
CREATE TABLE ORDERS(OID INT NOT NULL,CNAME CHAR(15),
PRODUCT VARCHAR(15),P_COST DECIMAL(10,2));
The SP_HELP Procedure Describes the Table like this ...:
No comments:
Post a Comment
Hi User, Thank You for visiting My Blog. Please post your genuine Feedback or comments only related to this Blog Posts. Please do not post any Spam comments or Advertising kind of comments which will be Ignored.