asked
How to get table definition with persisted column?
To generate object creation script, I used SSMS Tasks->Generate Scripts... Everything is fine in getting the compete object DDL script with/without data. But the problem lies with the tables having persisted column. When I run the generated script to create a DB, it creates all the objects except the tables having persisted columns. Is there any way I can get rid of this? I have to get the table created with persisted column as well. Regards, --Rudra
Are you getting an error? Are those objects in the script at all or are they just not appearing?
When I run the entire generated script, it just throws an error: Computed column 'column' in table 'table' cannot be persisted because the column is non-deterministic. And it proceeds with creating other objects.
Your error indicates that there is a problem with the persisted column. The calculation has to be completely deterministic. You can use the examples from the [Books Online here][1] to check the determinism on the columns. [1]:
http://msdn.microsoft.com/en-us/library/ms189292(SQL.90).aspx
In that case I need to manually remove the table script from the generated script.
15 People are following this question.
