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

Question

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

Anonymous User · Answer

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

Anonymous User

Can you answer this question?

1 Answers

Liked By