What is an alternating way of showing Table Structures in Sql Server?

Posted by vishalneeraj-24503 on 11/4/2014 | Category: Sql Server Interview questions | Views: 1303 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

sp_help is the an alternative way of displaying structure of table in Sql Server. sp_help is a system stored procedure.
Syntax:-

exec sp_help table_name;

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : Give an example of Sp_Help system stored procedure ...

Next > : What is the significance of DESCRIBE command in SQ ...

Comments or Responses

More Interview Questions by vishalneeraj-24503

What is the significance of DESCRIBE command in SQL Server?
What is the use of INTO keyword in LINQ?
How to get Age from any Date?
Give an example of ParseName function?
What do we mean by ParseName in-built function?
Which keyword or character is used to join 2 string in Sql Server?
Tell us about Statements regarding INTO keyword.
Which statements are correct about Dynamic Keyword?

Latest Interview Questions

__________ and __________ introduced with C#4.0 as a new features?
What is the calling order of components when angular js application st ...
In C#, the keyword used to pass the arguments by reference is?
In C#, the keyword used to access the base class members from the deri ...
In C#, the following keyword used to allocate the for a class's in ...
In C#, the keyword used to create an object to a class or struct is?
In C#, the process of grouping the related methods and variables (memb ...
C# doesn't support one of the following features. Find that?
More ...