I want to execute DESCRIBE query to view database table, but i am not able to as it shows error 'Incorrect syntax the keyword DESC'
You should use
sp_help to get what you want. This is SQL Server, not Oracle.
use yourDB; exec sp_help 'yourTable';
Reports information about a database object (any object listed in the sys.sysobjects compatibility view), a user-defined data type, or a data type.
sp only reads table
metadata, it does not modify anything.