Andy McW
04-08-2009, 01:57 PM
Hi guys, first time post here. Hope someone can help with the below question.
I am an analyst in financial services using MS SQL Server and therefore not a database designer or administrator.
I am querying a table which contains a column with a constraint of 1 or 0 which flags whether a row is active or closed. There must be a rule that decides which flag to use however I cannot find it.
I can use SP_HELPTEXT on a View to get the SQL statement that created it, but it does not seem to work on the table. The database is an old one, but kept in use for some old reports. The person that created the database and tables has long gone and nobody seems to be able to help.
Is there a way to get to this information?
Thanks and Regards
Andy
I am an analyst in financial services using MS SQL Server and therefore not a database designer or administrator.
I am querying a table which contains a column with a constraint of 1 or 0 which flags whether a row is active or closed. There must be a rule that decides which flag to use however I cannot find it.
I can use SP_HELPTEXT on a View to get the SQL statement that created it, but it does not seem to work on the table. The database is an old one, but kept in use for some old reports. The person that created the database and tables has long gone and nobody seems to be able to help.
Is there a way to get to this information?
Thanks and Regards
Andy