Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

find the all column with schema for any table in sql server

Varun Agrawal 2891 25 Mar 2011

How to find all column with schema for any table in sql server.
please give the example.
thanks in advance

2 Answers

Shankar M 09 Apr 2013

Hi Varun,

Alternatively you can try,

SP_HELP EMP in SQL Server

Here EMP is the table name

Thanks,

Shankar

Anonymous User 26 Mar 2011

Hi Varun,

You can try this to find all column with schema for any table in sql server.

select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=’table_name’

MindStick Training

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.