Get the table structure using SQL query in SQL Server

Posted By  youngmurukan On 16 Apr 2010 09:04:38
emailbookmarkadd commentsprint
No of Views:3019
Bookmarked:0 times
Votes:0 times

Introduction

In this code snippet to help to how to table structure using query in sql server.

  

SELECT Ordinal_Position,Column_Name,Data_Type,Is_Nullable,Character_Maximum_Length
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='table Name' 

I hope this help to you.

thank you

Sign Up to vote for this article
Other popular Tips/Tricks
Comments
There is no comments for this articles.
Leave a Reply
Title:
Display Name:
Email:
(not display in page for the security purphase)
Website:
Message:
Please refresh your screen using Ctrl+F5
If you can't read this number refresh your screen
Please input the anti-spam code that you can read in the image.
^ Scroll to Top
</