SELECT Count(*) FROM Syscolumns WHERE ID=(SELECT object_id('tablename'))

1.       DELETE and TRUNCATE removes rows or records from the table.

2.       DELETE can be used with WHERE clause. But not the TRUNCATE.

3.       DELETE can be rolled back, but not TRUNCATE

4.       DELETE raises TRIGGERS, but not the TRUNCATE

5.       DELETE does not reset the IDENTITY column

Run  sp_help 'TableName'