How to Describe table in SQL Server 2014

Hemanthkumar Naik picture Hemanthkumar Naik · Aug 8, 2016 · Viewed 12.3k times · Source

I am using SQLSERVER 2014 Express and I created Employee Table

I want to know the details Description for the Employee Table

like NULL or NOT NULL and Datatypes

In Oracle we have desc Employee like any syntax? Please help me

Answer

AntDC picture AntDC · Aug 8, 2016

SP_HELP will give info on an object:

exec sp_help 'objectName'