How to get field name with datatype and size In sql Query

Anonymous User 1919 03 Mar 2016

We want to get field name with datatype and size In sql Query. How will do this please help me.

Ask by Anonymous User

Updated 03 Mar 2016

1 Answers

Anonymous User 03 Mar 2016

CREATE TABLE [dbo].[Employee] (

    [EmpNo]       INT  IDENTITY (1, 1) NOT NULL,

    [EmpName]     VARCHAR (50) NOT NULL,

    [Salary]      DECIMAL (18) NOT NULL,

    [DeptName]    VARCHAR (50) NOT NULL,

    [Designation] VARCHAR (50) NOT NULL,

    PRIMARY KEY CLUSTERED ([EmpNo] ASC)

);

SELECT column_name as 'Column Name', data_type as 'Data Type',

character_maximum_length as 'Max Length'

FROM information_schema.columns

WHERE table_name = 'Employee'

Markdown for AI

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

Open .md

forum

How to get field name with datatype and size In sql Query

Can you answer this question?

1 Answers