What is the iPhone SMS database called in iOS 6?
Inside MobileSync/Backup/&lt;your_long_hex_string>/ you should find this file "3d0d7e5fb2ce288813306e4d4636395e047a3d28"

Then open it with SQLite (e.g. SQLite Firefox plugin or "sqlite database browser"), and execute this SQL query:

select message.rowid,
    case when message.date=0 then null else datetime(message.date,  'unixepoch', 'localtime', '+31 years') end as sent,
    case when message.date_delivered=0 then null else datetime(message.date_delivered,  'unixepoch', 'localtime', '+31 years') end as delivered,    
case when message.date_read=0 then null else datetime(message.date_read,  'unixepoch', 'localtime', '+31 years') end as read, 
    case when h1.id is not null then h1.id else h2.id end as interlocutor,
    case when message.is_from_me then null else message.text end as to_me,
    case when message.is_from_me then message.text else null end as from_me,
attachment.filename as attach,
    case when message.error=0 then null else message.error end as error_code
    from message 
    left join handle h1 on message.handle_id=h1.rowid
    left join message_attachment_join on message_attachment_join.message_id=message.rowid
    left join attachment on message_attachment_join.attachment_id=attachment.rowid
    left join  chat_message_join on chat_message_join.message_id=message.rowid
    left join  chat_handle_join  on chat_handle_join.chat_id=chat_message_join.chat_id
    left join  handle h2 on chat_handle_join.handle_id=h2.rowid
order by message.roWID