The documentation states that mssql_database.id should contain the database ID as in "SELECT DB_ID('')". But it actually holds the terraform resource id, which is actually expected behavior. I dont think the id property of terraform resources can or should be used for actual resource attributes. If I remember correctly its even a reserved property.
Anyways, would be nice if the actual database ID could be exposed on a property.
TLDL: mssql_database.id is not the database id, but the resource id
The documentation states that mssql_database.id should contain the database ID as in "SELECT DB_ID('')". But it actually holds the terraform resource id, which is actually expected behavior. I dont think the id property of terraform resources can or should be used for actual resource attributes. If I remember correctly its even a reserved property.
Anyways, would be nice if the actual database ID could be exposed on a property.
TLDL: mssql_database.id is not the database id, but the resource id