Microsoft SQL quick help

--Describe table in MS SQL
exec sp_columns My_Table;

--Check for indexes on given table
Select 
    SysIndex.object_id As ObjectId, 
    SysIndex.index_id As IndexId, 
    SysIndex.name As IndexName, 
    type As IndexType, 
    type_desc As IndexTypeDesc, 
    is_unique As IndexIsUnique, 
    is_primary_key As IndexIsPrimarykey, 
    fill_factor As IndexFillFactor, 
    SysIndexCol.column_id, 
    SysCols.name 
From 
    sys.indexes As SysIndex
    Inner Join sys.index_columns As SysIndexCol On SysIndex.object_id = SysIndexCol.object_id And SysIndex.index_id = SysIndexCol.index_id 
    Inner Join sys.columns As SysCols On SysIndexCol.column_id = SysCols.column_id And SysIndexCol.object_id = SysCols.object_id 
Where 
    type <> 0 
    And SysIndex.object_id in (Select systbl.object_id from sys.tables as systbl Where systbl.name = 'My_Table');