InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 22:14:32 GMT20http://www.sqlservercentral.com/Forums/Topic1374923-392-1.aspxI would have to know the version of SQL to know how to answer this.For 2008+, you have CDC.For SQL prior to that, they probably wouldn't like my answer, but I would make the schema identical to the original table, adding a column(s) to the original schema if needed to support the logging.This allows me to use all existing code and procs on the logging table, and/or to UNION ALL the two tables in such code/procs.Mon, 22 Oct 2012 14:27:17 GMTScottPletcherhttp://www.sqlservercentral.com/Forums/Topic1374923-392-1.aspxI'm not sure this is a schema question. There are technologies within SQL Server that will allow you to track changes, such as Change Data Capture. I'd suggest those before I'd suggest some other schema.Fri, 19 Oct 2012 11:10:13 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1374923-392-1.aspx[quote][b]rocky_498 (10/19/2012)[/b][hr]Some body ask this question during interview. I didn't the answer i would like to know if someone give me the answer of this simple or tuff question.Q) What would be your schema layout to track Update and delete from Table A..Please let me know if my question is not clear. I will try to provide more information. Thanks in advance.[/quote]The first thing for me would be a question. Are they wanting to track all updates and deletes from this table? If that is the answer then I would tell them that CDC is a great option for this.Fri, 19 Oct 2012 11:06:56 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1374923-392-1.aspxSome body ask this question during interview. I didn't the answer i would like to know if someone give me the answer of this simple or tuff question.Q) What would be your schema layout to track Update and delete from Table A..Please let me know if my question is not clear. I will try to provide more information. Thanks in advance.Fri, 19 Oct 2012 10:31:18 GMTrocky_498