SQL Server Interview Day - 5

November 29, 2017 0 Comments A+ a-

1) How can you describe table structure in sql server ?

sp_help tablename

The above query is used for the check table structure in SQL Server.
Ex:-
sp_help Tbl_Emp

2) How can you see text of stored procedure in sql server ?

sp_helptext storedprocedurename

The above query is used for see the text of stored procedure in sql server.
Ex:-
sp_helptext sp_EmpDetails