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

Anonymous User 1870 03 Mar 2016

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

Anonymous User

Other

I am a content writter !

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'

forum

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

Can you answer this question?

1 Answers