Current database schema, table name, Column name, data type, max length

Current database schema, table name, Column name, data type, max length, precision, scale, is_nullable, is_ansi_padded

SELECT OBJECT_SCHEMA_NAME(T.[object_id],DB_ID()) AS [Schema], 
        T.[name] AS [table_name], AC.[name] AS [column_name], 
        TY.[name] AS system_data_type, AC.[max_length],
        AC.[precision], AC.[scale], AC.[is_nullable], AC.[is_ansi_padded]
FROM sys.[tables] AS T 
  INNER JOIN sys.[all_columns] AC ON T.[object_id] = AC.[object_id]
 INNER JOIN sys.[types] TY ON AC.[system_type_id] = TY.[system_type_id] AND AC.[user_type_id] = TY.[user_type_id] 
WHERE T.[is_ms_shipped] = 0
ORDER BY T.[name], AC.[column_id]

sql reset id column

  How To: Reset Identity column in SQL Server

Deleted all the existing records

DBCC CHECKIDENT ('TableName', reseed, 0)